Transpose vs Pivot
The Tabular Transformation BizApp includes a Transpose Command that allows a the data set of delimited file to be rotated along the vertical or horizontal axis. The Transpose Command performs this action across all fields of the data set. This is not to be confused with a pivot action which rotates a single field along the vertical or horizontal axis. A Pivot Command is planned for a future release
Below is an example of the result of the Transpose Command.
Raw data before Command
Data after Command
Do you know when Pivot might be an option? Is there is a way I can accomplish turning multiple columns into a "measure" column and a data column?
Fld1,Fld2,Fld3,Col1,Col2,Col3,Col4,Col5,Col6,Col7
A, B, C, 1, 2, 3, 4, 5, 6, 7
X, Y, Z, 2, 4, 6, 8, 10, 12, 14
=====>
Fld1,Fld2,Fld3,Measure,Data
A, B, C, Col1,1
A, B, C, Col2,2
A, B, C, Col3,3
A, B, C, Col4,4
A, B, C, Col5,5
A, B, C, Col6,6
A, B, C, Col7,7
X, Y, Z, Col1,2
X, Y, Z, Col2,4
X, Y, Z, Col3,6
X, Y, Z, Col4,8
X, Y, Z, Col5,10
X, Y, Z, Col6,12
X, Y, Z, Col7,14
Mike,
Advanced Query can be used for this until we provide a Command. See an example based on your sample data: