I have a polygon shapefile (multipart) that I would like to pivot on a single field using ArcMap 10.4.

Everything works well but the final table miss the values of the pivoted field (that are important as well as others).

Can anyone explain me why it happens and how to solve it?

polygon shapefile with records resulting pivot table routine settings

I checked "GRIDCODE" and "CODE" with "CODE" as pivot

settings enter image description here

Checking "CODE" as Input and "GRIDCODE" as Pivot:

enter image description here enter image description here

  • What happens if you add CODE as well as GRIDCODE in your pivot? – smiller Oct 26 '18 at 17:38
  • I obtain a table that I can't use for my purpose and the problem of the CODE still persist. I could not add an image here but basically I obtain a table where there is a field "GRIDCODE" populated by zeros and field called with the "CODE" but populated in a strange way. – Riccardo Oct 26 '18 at 17:46
  • basically, it group the field "GRIDCODE" maintaning repeated values and put the values in the field "FID", then has created as many field as the values in "CODE" and named by it and it populated these fields with the "POLY_AREA" values but associating each value to the own proper "FID" and "CODE" – Riccardo Oct 26 '18 at 17:56
  • Haven't used this tool yet, so digging into docs. Have you tried using summarize? – smiller Oct 26 '18 at 17:56
  • What is your expected output? Is it correct to say you want column with code, separate columns for gridcode1000, gridcode3000, etc. With area as values in these columns, as displayed above? – smiller Oct 26 '18 at 17:59

Based on the image below (help for the tool), use your field "CODE" as the input, and "GRIDCODE" as the pivot. The output example more closely matches what you wanted as your output.

enter image description here

  • you are right, the result perfectly match with what I expected to have, like using the field "GRIDCODE" as input and "CODE" as the pivot, but the problem still persist, even with your proposed solution the field "CODE" results empty in the final table. – Riccardo Oct 26 '18 at 22:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.