topic Re: How to "summarize" in modelbuilder? in ModelBuilder Questions

How to "summarize" in modelbuilder?

GuillaumeRoyer — Wed, 30 Mar 2011 13:31:54 GMT

I work on ArcMAP 10
I usually use the summarize function by right-clicking on a column header in a table, and it does exactly what I need.
I want to do the same, but in modelbuilder. Basically, I need to see how many times each unique values appears in a field, and I need the result in a new table. I tried the summary statistic tool, but I can only get it to calculate the number of entries in a particular field.
I am fairly new to GIS so I may be missing something obvious.

Thanks.

Re: How to "summarize" in modelbuilder?

EricMartinson — Wed, 20 Feb 2013 13:19:01 GMT

Salut Guillaume-
Did you ever find an answer to your question? I'm looking for the same thing. I doubt we'll get help from ESRI, as their resources are devoted to putting out crappy new software versions instead of fixing and documenting issues in the old ones...
--Eric

Re: How to "summarize" in modelbuilder?

BradBolton1 — Fri, 24 Mar 2023 21:13:54 GMT

I've barely used modelbuilder....So I'm trying something new to me. I have a layer with a text field (with words, not numbers), with around 30,000 records. I want to remove duplicates and just leave the unique values in a new table, which leaves about 29,000 records when I do it manually (right-click on field header in attribute table & summarize). Anyone know if this is possible in modelbuilder? I'm striking out.

Re: How to "summarize" in modelbuilder?

curtvprice — Fri, 07 Apr 2023 16:36:59 GMT

Here are are a few tools that may work for you:

Summary Statistics (this is the tool equivalent to your right-click / Summarize interactive workflow)
Frequency (requires ArcInfo license)
Delete Identical

Hope this helps you out!

Re: How to "summarize" in modelbuilder?

BradBolton1 — Mon, 10 Apr 2023 16:02:08 GMT

Thanks for your reply Curt. For whatever reason, I couldn't figure out the Summary Statistics tool option. It doesn't seem to operate the same as right-click/summarize--admittedly, I've never used this tool.

What I ended up doing, was using the Dissolve tool. My layer is a polygon layer, and dissolve worked well to get unique attribute values into their own records.

Re: How to "summarize" in modelbuilder?

curtvprice — Thu, 13 Apr 2023 21:29:42 GMT

Dissolve - I didn't think of that!

Summary Statistics is entirely equivalent to the ArcMap right click summarize (with more functionality, including multiple case items). Note that in ArcGIS Pro, a right click summarize there opens the Summary Statistics tool.

Re: How to "summarize" in modelbuilder?

BradBolton1 — Fri, 14 Apr 2023 13:08:37 GMT

Good to know, thanks!