Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a data table that I need to trim down, merging records which have the same value in an ID field and performing a couple math operations on various other fields (summing, averaging). The Dissolve tool in ArcGIS does this for feature classes, but it doesn't work on tables. I realize there's probably a tool in ArcGIS that does this (it's basically a Dissolve with no geometry) but I haven't found it and am in a bit of a hurry.

Is there one? I have an ArcInfo license available if necessary.

share|improve this question
See this related question, specifically Justin's answer and Dan Patterson's comment: gis.stackexchange.com/questions/19383/… –  blah238 Feb 2 '12 at 22:15

3 Answers 3

up vote 14 down vote accepted

You can do this with the Summary Statistics (Analysis) tool. The case field parameter is what you use to "dissolve". From the above link:

case_field [case_field,...] (Optional) The fields in the Input Table used to calculate statistics separately for each unique attribute value (or combination of attribute values when multiple fields are specified).

share|improve this answer

This sounds like you need to look at the Summary Statistics tool which I find to be a bit of a Swiss Army Knife in that it comes with a Basic (formerly called) ArcView level license and can often be used in place of Frequency (that needs Advanced/ArcInfo) and PULLITEMS (that needs ArcInfo Workstation:-) to reorder fields.

share|improve this answer

The Dissolve_management tool works on tables as well as feature classes.

share|improve this answer

protected by whuber Nov 15 '12 at 16:41

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.