Help Desk

Submit a ticket My Tickets
Welcome
Login

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:

    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


Login to post a comment