Did ArcGISpro/Desktop lose some functionality recently? I am trying to join two tables to find which records don't have a match in the other. "Keep All Records" is selected in the join but it does not keep all records. It only keeps the ones there are matches for. I've done this hundreds of times and now it doesn't work. I have the same problem in ArcGIS Pro as well. Does anyone know what is going on? How can I work around this?
My two tables:
My join settings:
Resulting join:
Solved! Go to Solution.
did you try some of the other join access tools like
Add Join (Data Management)—ArcGIS Pro | Documentation
Join Field (Data Management)—ArcGIS Pro | Documentation
did you try some of the other join access tools like
Add Join (Data Management)—ArcGIS Pro | Documentation
Join Field (Data Management)—ArcGIS Pro | Documentation
Sir, thank you. That did it! I am very grateful.