nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add Join Not Working

SujanShrestha

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.

Find more posts tagged with

Analysis

Geodatabase

Accepted answers

SujanShrestha

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

All comments

BenjamenWetherill

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?

SujanShrestha

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

JayantaPoddar

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.