Transpose Utility Function

Transpose

Transpose functions converts columns to rows against the selected key. It requires selecting.

• Key Column - this remains constant in the result set and repeats per data column type

• Data Columns - columns that need to be transposed as rows

• Column for transposed Data field - name of the column that would contain the pre-transpose data column names

• Column for transposed Data field value - name of the column that would contain the pre-transpose data column’s values

For example consider the below dataset

ID	City	State
1	San Jose	California
2	San Diego	California
3	Detroit	Michigan

Applying transpose function to the above dataset with Key as ID, Data Column as City & State, Column for transposed data field as ‘New_Field’ & Column for transposed Data field value as ‘Field_Value’ would result in the following dataset

ID	New_Field	Field_Value
1	City	San Jose
1	State	California
2	City	San Diego
2	State	California
3	City	Detroit
3	State	Michigan