idea GP tool to populate COUNT field with count of attribute occurrences in ArcGIS Pro Ideas https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idi-p/1609370 <P><EM>ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB or file geodatabase</EM></P><P>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.</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%">ID</TD><TD width="50%">COUNT</TD></TR><TR><TD width="50%">1</TD><TD width="50%">1</TD></TR><TR><TD width="50%">2</TD><TD width="50%">1</TD></TR><TR><TD width="50%">3</TD><TD width="50%"><STRONG>2</STRONG></TD></TR><TR><TD width="50%">3</TD><TD width="50%"><STRONG>2</STRONG></TD></TR><TR><TD width="50%">4</TD><TD width="50%">1</TD></TR></TBODY></TABLE><P><BR />If I understand correctly, there isn't a GP tool that can do that. Could a tool be added?</P> Fri, 25 Apr 2025 20:02:17 GMT Bud 2025-04-25T20:02:17Z GP tool to populate COUNT field with count of attribute occurrences https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idi-p/1609370 <P><EM>ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB or file geodatabase</EM></P><P>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.</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%">ID</TD><TD width="50%">COUNT</TD></TR><TR><TD width="50%">1</TD><TD width="50%">1</TD></TR><TR><TD width="50%">2</TD><TD width="50%">1</TD></TR><TR><TD width="50%">3</TD><TD width="50%"><STRONG>2</STRONG></TD></TR><TR><TD width="50%">3</TD><TD width="50%"><STRONG>2</STRONG></TD></TR><TR><TD width="50%">4</TD><TD width="50%">1</TD></TR></TBODY></TABLE><P><BR />If I understand correctly, there isn't a GP tool that can do that. Could a tool be added?</P> Fri, 25 Apr 2025 20:02:17 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idi-p/1609370 Bud 2025-04-25T20:02:17Z Re: GP tool to populate COUNT field with count of attribute occurrences https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idc-p/1609432#M34613 <P>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.&nbsp;&nbsp;</P> Fri, 25 Apr 2025 21:27:56 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idc-p/1609432#M34613 DavidPike 2025-04-25T21:27:56Z Re: GP tool to populate COUNT field with count of attribute occurrences https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idc-p/1610041#M34632 <P>Maybe the&nbsp;<A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/frequency.htm" target="_self">Frequency Tool</A>&nbsp;would be of use?&nbsp; Frequency can give you a table with all the unique values and the the counts, but if&nbsp; you need the table to look the way you pictured it, some extra table manipulation is going to be required.</P> Tue, 29 Apr 2025 15:58:42 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-populate-count-field-with-count-of/idc-p/1610041#M34632 MarkBockenhauer 2025-04-29T15:58:42Z