topic Re: Deleting multiple rows in attribute table (conditional, where there are 10 records of less) in Data Management Questions

Deleting multiple rows in attribute table (conditional, where there are 10 records of less)

Kate_Gormley_abdn — Wed, 09 Feb 2022 15:44:48 GMT

Hi,

I need to select and delete records from an attribute table where there are fewer than 10 records/rows for a particular field (shipid). Unfortunately the data set is very large, so it's not possible to do it manually. So wondered if there is a way of doing this via select attribute? or similar? I'm working with ArcPro. Thanks

Re: Deleting multiple rows in attribute table (conditional, where there are 10 records of less)

DanPatterson — Wed, 09 Feb 2022 15:55:44 GMT

Are they duplicates?

Find Identical (Data Management)—ArcGIS Pro | Documentation

Delete Identical (Data Management)—ArcGIS Pro | Documentation

read carefully before you do anything... and try on a copy of the file if this is what you are after

Re: Deleting multiple rows in attribute table (conditional, where there are 10 records of less)

Kate_Gormley_abdn — Wed, 09 Feb 2022 15:59:04 GMT

Maybe not quite, but will have a look thanks - the shipID is identical for lots of records, but I only want to delete where there are less than 10 records. (some may have 100's of points for the same shipid for example)

Re: Deleting multiple rows in attribute table (conditional, where there are 10 records of less)

DanPatterson — Wed, 09 Feb 2022 16:08:55 GMT

You would have then summarize statistics on that field (a count obviously) to identify those candidates first

Summary Statistics (Analysis)—ArcGIS Pro | Documentation

once found (sort descending on the count) you could then delete what you want