I have an attribute table with one single value and an attribute table with different rows. I want to join the single entry to all rows from the other table, without using a certain join field on which the join will be based. In SQL it would be a cross Join.

table 1     table 2 cross joined
x             a | d | c | x
              o | e | t | x
              f | b | c | x

Is that possible in ArcGIS Pro?

  • 1
    Just add a new field to table 2 and then do a field calculate on your new field to populate it with "X".
    – Hornbydd
    Commented May 21, 2022 at 14:48
  • It should work with the model builder automatically.
    – emukis
    Commented May 31, 2022 at 12:23

1 Answer 1


At the end the quick and dirty solution "Join Field" -> "Fill Missing Values" (with this tool, missing values can be filled from the one field with a value) worked for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.