topic Re: Dissolve tool for table features in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675427#M22409 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Use the <A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00080000001z000000">Summary Statistics tool</A>.<BR /><BR />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).</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Thank you. That worked out great!:)</SPAN></BODY></HTML> Fri, 23 Aug 2013 17:36:55 GMT ShikoNjuno 2013-08-23T17:36:55Z Dissolve tool for table features https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675425#M22407 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><SPAN>See below:</SPAN><BR /><SPAN>[ATTACH=CONFIG]26927[/ATTACH]</SPAN><BR /><SPAN>So what I want to do is essentially truncate the entire table so it has just an average "dbthirdbar" value for each unique MUKEY.</SPAN><BR /><SPAN>Any suggestions welcome.</SPAN><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Fri, 23 Aug 2013 16:35:31 GMT https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675425#M22407 ShikoNjuno 2013-08-23T16:35:31Z Re: Dissolve tool for table features https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675426#M22408 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">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.<BR />See below:<BR />[ATTACH=CONFIG]26927[/ATTACH]<BR />So what I want to do is essentially truncate the entire table so it has just an average "dbthirdbar" value for each unique MUKEY.<BR />Any suggestions welcome.<BR />Thanks.</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Use the </SPAN><A class="jive-link-external-small" href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00080000001z000000" rel="nofollow" target="_blank">Summary Statistics tool</A><SPAN>.</SPAN><BR /><BR /><SPAN>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).</SPAN></BODY></HTML> Fri, 23 Aug 2013 17:20:48 GMT https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675426#M22408 RichardFairhurst 2013-08-23T17:20:48Z Re: Dissolve tool for table features https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675427#M22409 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Use the <A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00080000001z000000">Summary Statistics tool</A>.<BR /><BR />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).</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Thank you. That worked out great!:)</SPAN></BODY></HTML> Fri, 23 Aug 2013 17:36:55 GMT https://community.esri.com/t5/geoprocessing-questions/dissolve-tool-for-table-features/m-p/675427#M22409 ShikoNjuno 2013-08-23T17:36:55Z