Joining table to features class broken?

Question

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?

Eugene_Adkins · Answer

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?

BarryNorthey · Answer

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

mvolz47 · Answer

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.