SAP Business Objects Data Services - Reverse Pivot Transform

Reverse Pivot Transformation is used to Convert Rows Values of table\file in to Column Values.it creates a new column for every value that is specified as a pivoted column. Hence to summarize, this transforms converts row values to column values.

Creates one row of data from several existing rows. The Reverse Pivot transform allows you to combine data from several rows into one row by creating new columns. For each unique value in a pivot axis column and each selected pivot column, Data Services produces a column in the output data set.

              Design the flow as above.

            In the first query, do the simple mapping.

           In the Transform, do the relevant mapping and click “validate”.

       In the second query also, do a simple mapping.