topic Re: Transposing or Splitting a Table in Arc in Geoprocessing Questions

Transposing or Splitting a Table in Arc

MelissaSlater — Mon, 12 May 2014 20:52:01 GMT

I have an output table with 2 columns and 2 rows and I need to consolidate the information into just 1 row. I've tried creating a pivot table but it does not quite work (still retains 2 rows). I've attached a couple screen grabs that illustrate the current table and the table that I need. Unfortunately I cannot do this manually as this needs to be done for several hundred tables and I need to find a tool I can iterate through in Model Builder. Ultimately I need to apply each of these values in a Raster Calculator.
Any suggestions?
Thanks!
Melissa

Re: Transposing or Splitting a Table in Arc

Anonymous User — Mon, 12 May 2014 23:55:17 GMT

Original User: rfairhur24

I have an output table with 2 columns and 2 rows and I need to consolidate the information into just 1 row. I've tried creating a pivot table but it does not quite work (still retains 2 rows). I've attached a couple screen grabs that illustrate the current table and the table that I need. Unfortunately I cannot do this manually as this needs to be done for several hundred tables and I need to find a tool I can iterate through in Model Builder. Ultimately I need to apply each of these values in a Raster Calculator.
Any suggestions?
Thanks!
Melissa

You would need another column for a unique ID number that would consolidate the data using the Pivot Table tool. For example, you could use the Add Field tool to add a field called MY_ID and the Field Calculator tool to calculate all of the values of that field to 1 or some text value that could later act as a join value. Then use that repeated value as the unique case field, the text field as the Field Names field and the numeric field as the Values field. That should pivot the values to a single row beginning with the MY_ID value, then the two named fields each with the numbers associated to them that you want.

Re: Transposing or Splitting a Table in Arc

Anonymous User — Tue, 13 May 2014 13:12:01 GMT

Original User: mslater06

THANK YOU!
I have been trying to figure this out for over a week. This is the perfect work around!
Thanks!

You would need another column for a unique ID number that would consolidate the data using the Pivot Table tool. For example, you could use the Add Field tool to add a field called MY_ID and the Field Calculator tool to calculate all of the values of that field to 1 or some text value that could later act as a join value. Then use that repeated value as the unique case field, the text field as the Field Names field and the numeric field as the Values field. That should pivot the values to a single row beginning with the MY_ID value, then the two named fields each with the numbers associated to them that you want.