I have two NRCS soil tables I am wanting to join together so I can calculate a custom field from an old dataset to the new one.
The two tables both have a key field that matches. When I join the tables on the key field in ArcMap, 11,000 records of 15,000 join together, which is what I am expecting.
When I do the same join in ArcGIS Pro, only about 2000 records join up.
I'm hoping there is an explanation to why this is happening, maybe I am missing something in Pro?
Thank you.
Validate Join (Data Management)—ArcGIS Pro | Documentation
will check to see if there are issues prior to actually doing a join... any issues reported?