topic Re: Summerize attribute fields in new row, then add as new field to another shapefile in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471168#M15773 <HTML><HEAD></HEAD><BODY><P>Do you mean the <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//0017000000v4000000">Transpose tool</A> ?</P></BODY></HTML> Fri, 01 Aug 2014 20:42:36 GMT DanPatterson_Retired 2014-08-01T20:42:36Z Summerize attribute fields in new row, then add as new field to another shapefile https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471166#M15771 <HTML><HEAD></HEAD><BODY><P>I am interested to know if someone could help me figure out this problem for a class project.</P><P>I have done some analysis: </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I would like to insert a new row that has the sum of each attribute field. I have tried using summary statistics tool but only get an error in the statistics field(s) parameter. I would also need to automate this process because in some cases there are 50 parks in the layer.&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Park 1_ sales&nbsp;&nbsp;&nbsp;&nbsp; Park 1 _prob&nbsp;&nbsp;&nbsp;&nbsp; Park 2_sales&nbsp;&nbsp;&nbsp;&nbsp; Park 2_ prob&nbsp;&nbsp;&nbsp;&nbsp; (made up numbers to show layout)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .9</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .6</P><P>New row: Sum=&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp;&nbsp; Then,&nbsp; I have the park layer. I would like to create two new fields and populated them with the summary row information</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sales&nbsp;&nbsp;&nbsp;&nbsp; prob</P><P>Park 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .8</P><P>Park 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.5</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Please let me know if you have any advice or if I need to be clearer.</P></BODY></HTML> Thu, 31 Jul 2014 19:28:13 GMT https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471166#M15771 ChelseyAiton1 2014-07-31T19:28:13Z Re: Summerize attribute fields in new row, then add as new field to another shapefile https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471167#M15772 <HTML><HEAD></HEAD><BODY><P>I was able to figure out the first half of the problem and create a script to automate the process. The second half is the tricky part. Have a horizontal row become two vertical columns...</P><P><A href="http://www.pinterest.com/pin/create/extension/">http://www.pinterest.com/pin/create/extension/</A></P></BODY></HTML> Fri, 01 Aug 2014 20:30:20 GMT https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471167#M15772 ChelseyAiton1 2014-08-01T20:30:20Z Re: Summerize attribute fields in new row, then add as new field to another shapefile https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471168#M15773 <HTML><HEAD></HEAD><BODY><P>Do you mean the <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//0017000000v4000000">Transpose tool</A> ?</P></BODY></HTML> Fri, 01 Aug 2014 20:42:36 GMT https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471168#M15773 DanPatterson_Retired 2014-08-01T20:42:36Z Re: Summerize attribute fields in new row, then add as new field to another shapefile https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471169#M15774 <HTML><HEAD></HEAD><BODY><P><A href="http://www.pinterest.com/pin/create/extension/">http://www.pinterest.com/pin/create/extension/</A>Dan,</P><P></P><P>Yes thank you! I had not heard of or stumbled upon this tool in my research.</P></BODY></HTML> Fri, 01 Aug 2014 21:06:14 GMT https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471169#M15774 ChelseyAiton1 2014-08-01T21:06:14Z Re: Summerize attribute fields in new row, then add as new field to another shapefile https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471170#M15775 <HTML><HEAD></HEAD><BODY><P>Chelsey, closing the thread would help others find a solution, if the help did indeed resolve your issue</P></BODY></HTML> Fri, 01 Aug 2014 21:08:03 GMT https://community.esri.com/t5/geoprocessing-questions/summerize-attribute-fields-in-new-row-then-add-as/m-p/471170#M15775 DanPatterson_Retired 2014-08-01T21:08:03Z