Skip to main content
Question

Transpose time fields similar to ArcGIS

  • March 29, 2017
  • 1 reply
  • 9 views

Forum|alt.badge.img

Hi All,

I am trying to transpose data in the same way that ArcGIS does with the Transpose Fields tool (http://pro.arcgis.com/en/pro-app/tool-reference/data-management/transpose-fields.htm) but I am not able to do it. Anyone could shed some light? Thanks.

1 reply

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • March 29, 2017

Hi @kpeng, generally it's possible if each feature has these three kinds of attributes.

  • <name>: stores a string value that will be used as a new attribute name after transposing.
  • <value>: stores a value that will be saved into the new attribute
  • <id>: stores unique ID for new features after transposing

The procedure would be:

  1. Rename <value> to the value of <name> for each feature (or create a new attribute whose name is the value of <name> and stores the value of <value>).
  2. Aggregate the features and merge their attributes, with setting <id> to the Group By parameter.
  3. Optionally expose the new attribute names (i.e. all the possible values of <name>).


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings