Transpose vs Pivot

Tony Scalese

started a topic 7 months ago

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

M

Mike Staib
said about 1 month ago

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

Tony Scalese

said about 1 month ago

Mike,

Advanced Query can be used for this until we provide a Command. See an example based on your sample data:

Select Fld1, Fld2,Fld3, 'Col1' as Measure, Col1 as Data from Fact
UNION
Select Fld1, Fld2,Fld3, 'Col2' as Measure, Col2 as Data from Fact
UNION
Select Fld1, Fld2,Fld3, 'Col3' as Measure, Col3 as Data from Fact

Didn't find what you were looking for?

Start a new topic

Transpose vs Pivot

Topics in this forum

Didn't find what you were looking for?