topic Re: Identical values in a field in Geoprocessing Questions

Identical values in a field

JerrySmart — Fri, 12 Apr 2013 19:33:21 GMT

I have multiple identical values within a field in an attribute table and would like to delete them. I am using ArcEditor version 10, sp5. I tried to use the Delete Identical tool in Python but get the "you are not licensed for this tool" message. there must be another way to accomplish this that I am not aware of. Any help would be appreciated.

Re: Identical values in a field

MelanieSummers — Fri, 12 Apr 2013 19:53:32 GMT

Hello,

The Delete Identical Tool is only available at the ArcInfo license level which is why you are getting that message. Do you want to delete the features or just the values in the attribute table? Do you want all identical values to be deleted or to only delete one of them?

Best,
Melanie S.

Re: Identical values in a field

JerrySmart — Fri, 12 Apr 2013 20:06:37 GMT

Hello,

The Delete Identical Tool is only available at the ArcInfo license level which is why you are getting that message. Do you want to delete the features or just the values in the attribute table? Do you want all identical values to be deleted or to only delete one of them?

Best,
Melanie S.

I would like to delete all but one of the duplicate features and values.
Thanks.

Re: Identical values in a field

MelanieSummers — Fri, 12 Apr 2013 20:08:53 GMT

Hi,

Do you care which one is deleted?

Melanie S.

Re: Identical values in a field

JerrySmart — Fri, 12 Apr 2013 20:28:39 GMT

Mostly, no, but there are a few that could be a problem.

Re: Identical values in a field

MelanieSummers — Fri, 12 Apr 2013 21:53:55 GMT

Hello,

Attached in a python script that will select all duplicate records. This will at least ID which ones you need to go through, I would not suggest automating the deleting process as you are not sure which one needs to be deleted.

Best,
Melanie S.

Re: Identical values in a field

JerrySmart — Mon, 15 Apr 2013 12:47:35 GMT

Thank you very much for your help.