Select to view content in your preferred language

Joining table to features class broken?

447
3
03-04-2024 09:29 AM
neomapper
Frequent Contributor

Has anyone had trouble with the join tool not working to join all values in a table to values in a feature class when they shared the exact same identification? We have a little over 140 features from the table that will not join with a feature class value. I copied the exact identification id from the table to the feature class value and that still doesn't work. Thoughts? 

 

neomapper_0-1709572693053.png

 

0 Kudos
3 Replies
MichaelVolz
Esteemed Contributor

Maybe the values in either the feature class or table having trailing spaces.  As a test create a new field where you right trim the values and see if you have better results with the join.

0 Kudos
BarryNorthey
Frequent Contributor

It looks like you have a selection. Try clearing the selection and running again.

0 Kudos
Eugene_Adkins
Frequent Contributor

Do you have a definition query applied to the layer or the table? Definition queries can create issues if they are applied before a join is created.

Also, according to your description this probably will not be the issue, but have you tried copying the unique identifier from the layer and the table and pasting them into Excel and then using Excel (conditional formatting / duplicate values) to make sure you have a one-to-one match for the entry?

0 Kudos