Skip to main content

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.

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