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

1848
3
02-09-2022 07:44 AM
Labels (1)
Kate_Gormley_abdn
New Contributor II

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

Kate_Gormley_abdn_0-1644421403394.png

 

0 Kudos
3 Replies
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
Kate_Gormley_abdn
New Contributor II

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)

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...