The UnPivot data transformation converts columns to 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:
For example, a dataset that lists shops’ sales has one row for each shop, with the month and the sales amount shown in columns in the row.
The following diagram shows a data pivot with multiple columns:
For example, a file that holds a list of products bought by the customer with product codes delimited by 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 a data after it has been unpivoted:
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