topic Re: Select features that have identical values in Geoprocessing Questions

Select features that have identical values

Emilbrundage — Thu, 05 Dec 2013 21:23:50 GMT

I am trying to select features that have duplicate values in an attribute. I found this:

http://forums.arcgis.com/threads/82221-Identical-values-in-a-field?highlight=select+duplicate

But when I run the python tool I get:

File "C:\E1B8\IM_Reconciliation\Toolbox.tbx#SelectDuplicates.py", line 31, in <module>
NameError: name 'SelectPoly' is not defined

Any help?

Much thanks!

Re: Select features that have identical values

TimWitt — Fri, 06 Dec 2013 11:14:02 GMT

Emil,

Maybe you can try this instead?

Tim

Re: Select features that have identical values

RichardFairhurst — Fri, 06 Dec 2013 12:05:43 GMT

This is what the Summary Statistics tool is for. Make your case field whatever makes sense as the unique grouping value (the field with duplicates in this case) and get the minimum ObjectID as a summary value. Then look for any Frequency > 1 in the summary table. You can join the Summary table to the original data on the case field and then use the Min_ObjectID value to select all others records than the first one to consider invalid, if that is your business rule, or just select all of the records with duplicates if that makes more sense. A calculation based on the Min_objectID can also do the assignment of 1 or 0 to an alternative field if you like. You can alternatively use a relate to separately select each of the duplicate value groups if they need to be evaluated and operated on by each group individually (a 1 or 0 in another field won't let you do that).

Re: Select features that have identical values

Emilbrundage — Fri, 06 Dec 2013 19:58:50 GMT

Thanks, that works great!