Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
1  
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
up vote 16 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 answer is correct for the specific question; however, I want to provide a warning to those who may be looking to dissolve without any statistics fields: it won't work. You must submit a statistics field. If you're looking to "dissolve" a table but not calculate summary statistics, then you can use the Delete Identical tool. desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/… – Tom Jul 12 at 16:58

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
1  
? In arcgis desktop 10.3.1 I get an "One or more dropped items were invalid and will not be added to the control." error. (ArcToolbox >> Data Management Tools >> Generalization >> Dissolve) – matt wilkie Dec 10 '15 at 18:37

protected by whuber Nov 15 '12 at 16:41

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

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.