Does anyone know if there is a way to dissolve table rows that have duplicate attributes in one field, by performing a MEAN statistic on another attribute field. The table is created to have just these two fields but there are multiple values for many of other values in the other field.
See below:
[ATTACH=CONFIG]26927[/ATTACH]
So what I want to do is essentially truncate the entire table so it has just an average "dbthirdbar" value for each unique MUKEY.
Any suggestions welcome.
Thanks.
Use the Summary Statistics tool.Alternatively you could right click on the MUKEY field in a table view and use the Summarize context menu item to do the same thing (but more limited than the Summary Statistics tool, so I recommend using Summary Statistics most of the time, since it can deal with multiple field key fields, perform field reordering, and do other statistics that the Summarize tool can't).
