Add Join Not Working

4241
2
Jump to solution
02-10-2022 07:42 AM
Labels (2)
SujanShrestha
New Contributor II

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. 

 

SujanShrestha_0-1644507688032.png

There should've been 1574 matching records.

0 Kudos
1 Solution

Accepted Solutions
SujanShrestha
New Contributor II

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

View solution in original post

2 Replies
JayantaPoddar
MVP Esteemed Contributor

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.

JayantaPoddar_0-1644509037417.png

 



Think Location
0 Kudos
SujanShrestha
New Contributor II

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