Select to view content in your preferred language

GP tool to populate COUNT field with count of attribute occurrences

261
2
04-25-2025 01:02 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB or file geodatabase

A user who is not a SQL or Python person has a standalone table with an ID field. The user wants to populate a COUNT field with counts of the IDs.

IDCOUNT
11
21
32
32
41


If I understand correctly, there isn't a GP tool that can do that. Could a tool be added?

2 Comments
DavidPike

2 steps could be Summary Statistics then join the tables together after, but appreciate this is an idea request rather than looking for a solution.  

MarkBockenhauer

Maybe the Frequency Tool would be of use?  Frequency can give you a table with all the unique values and the the counts, but if  you need the table to look the way you pictured it, some extra table manipulation is going to be required.