I am having an issue using Joins with ArcGIS Pro.
The goal here is to join the two tables by the 'PermitNumber' field in the 'mineralsCat' table and the 'mineid' field in the 'mineralsStatus' table.
See table below:
For context, these are permit numbers for mineral mines in my state.
Things I have checked for:
Things I have tried:
Screenshot showing that the field types are the same:
Screenshot showing the warning about no join matches:
I would appreciate any ideas that you have related to ArcPro, Excel, pandas, and/or numpy. I have not yet tried any coding solutions, but maybe pandas data frames could be the solution. Though I'm not sure.
Solved! Go to Solution.
It could just be because you are showing a subset of the data, but I am seeing an extra leading zero in the mineralsCat table that does not exist in the mineralsStatus table.
M00100001 vs
M0100001
It could just be because you are showing a subset of the data, but I am seeing an extra leading zero in the mineralsCat table that does not exist in the mineralsStatus table.
M00100001 vs
M0100001
Oh, shoot. What a silly thing to miss. Thank you.