[GIS] Performing full outer join using ArcMap

arcgis-desktoparcmapattribute-joins

Does anybody know how to perform a full outer join with ArcMap?

I have the following two tables:

Table A
Joinkey
1
2
3

Table B
Joinkey Other_field
1 1
1 2
1 3

The result should be something like:

Joinkey_A Joinkey_B Other_field
1 1 1
1 1 2
1 1 3

But ArcMap does the following (inner join):

Joinkey_A Joinkey_B Other_field
1 1 1
2 2 1
3 3 1

In my opinion this means, I need a full outer join but I cannot find any solution for this.

Best Answer

The Add Join tool might be for what you are looking.

Under the join_type parameter, here is the description of the valid inputs:

  • KEEP_ALL —All records in the input layer or table view will be included in the output—also known as an outer join. This is the default.
  • KEEP_COMMON —Only those records in the input that match to a row in the join table will be present in the result—also known as an inner join.
Related Question