topic Add Join Not Working in ArcGIS Pro Questions

Add Join Not Working

SujanShrestha — Thu, 10 Feb 2022 15:42:09 GMT

I have two layers All Parcels (4k features) and Residential Parcels(1k parcels), a subset of All Parcels. Same parcels in both the layers have identical joinIDs. When I try to join the all parcels to residential parcels, Pro says it has matched only 100 records.

This has happened multiple times. I've tried to export features to tables and join it but the issue persists. If I do a join in Excel, all the records have a match.

There should've been 1574 matching records.

Re: Add Join Not Working

JayantaPoddar — Thu, 10 Feb 2022 16:05:12 GMT

Are the input and Join fields of both the tables of TEXT datatype?

Could you check if there are any leading or trailing space(s) in the Join fields?

strip() function (Calculate Field) can help you to get rid of the unwanted spaces at the ends.

Re: Add Join Not Working

SujanShrestha — Thu, 10 Feb 2022 16:35:22 GMT

Thanks for the reply! I do not have any extra spaces but when I recreated attribute indexes for the layers - it worked.

Re: Add Join Not Working

BenjamenWetherill — Sun, 15 Sep 2024 16:44:08 GMT

I had the same issue and was only able to solve it with indexing. In the Add Join tool, I had to select both Index joined fields and Rebuild Joined Fields Indexes. This is quite annoying that this issue happens. Why do you have to reindex the fields? And why aren't these two options defaults if they are so necessary?