SAP Business Objects Data Services - Pivot Transform

Pivot Transformation is used to Convert Column Values of table\file in to Row Values.
The Pivot transformation makes a normalized data set into a less normalized but more
compact version by pivoting the input data on a column value.

Drag a source table

Then a “Pivot” transform and template table.

Make three are connected.

By double clicking open the pivot transform.

Drag the “Non_Pivot and Pivot” column names.

-          Give relevant column names according to the data types.

-          Compare the results.