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; } } }

Find missing items in a table join

JoshuaMuller

Hi Everyone,

I am curious, is there a simple way to find which values are missing when I do a table join? I am linking 1330 items from a table to a point shapefile but only 1273 are linked. I would like to know which ones were missed so that I can determine the error in the missed items. Thanks!!

Josh

Trouver plus de publications taguées avec

Accepted answers

All comments

JeffWard

You may have to remove your original join before you set up the relate.

JeffWard

The methods I mentioned above will select the records in your source table that don't have a corresponding feature in your shapefile. If you want to select features that don't have a matching record in the stand alone table I would use a relate. Relate the standalone table to the shapefile, select all of the records in your table and click on the "Related Tables" button along the top of the table window -

That's going to give you all of the features that match your table. Reverse the selection and you have the features that don't match.

SepheFox

Joshua, the method Jeff is describing will work, but you need to reverse the join first, that is join the smaller table to the larger one, and you can then see which rows of the larger table has null entries for the point fields. As he said, make sure you keep all records in the join.

JeffWard

The above methods should still work. Open the big table, run a select by attributes and select records where shapefile.FID IS NULL. These would be records that have no matching feature in the shapefile. That is, if when you set up the join you used the "Keep all records" in the join options.

JoshuaMuller

Thank you Jeff. Key is that i linked the larger table to the smaller one. I have always been doing it the other way around which doesn't help.

JeffWard

Or select by attributes where JoinedField IS NULL.

JeffWard

I sort one of the joined fields in ascending order. Nulls are at the top.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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