The Unpivot data transformation converts columns into rows. It takes an unnormalized dataset and turns it into a normalized version by expanding values from multiple columns in a single record into multiple records with the same values in a single column.
There are two different kinds of Pivot tables
1.Multiple columns Pivot
For example, a dataset that lists shops' sales has one row for each shop, with a month and the sales amount shown in columns in the row.
The following diagram shows a data pivot with multiple columns.
2. Single column Pivot
For example, a file that holds a list of products bought by the customer with product codes delimited by a semicolon.
The following picture shows a data pivot with a single pivot column.
After the Unpivot transformation normalizes the data set, the data set contains a different row for each product that the customer purchased.
The following diagram shows data after it has been unpivoted.
Configuring the Unpivot Transformation
- To change UnPivot properties double click on the object.
- Fill in Description and select appropriate Pivot type
Following actions apply only to Multiple fields Pivot
- Create all necessary Groups and Outputs
- Once it is done Map Input fields to Outputs and Groups