Question

Transpose time fields similar to ArcGIS

  • 29 March 2017
  • 1 reply
  • 3 views
K
Badge

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
Rank
Userlevel 2
Badge +17

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


Community Stats

28,696
Posts
109,442
Replies
36,546
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.