Export (0) Print
Expand All
Expand Minimize

Unpivot Transformation Editor

Use the Unpivot Transformation Editor dialog box to select the columns to pivot into rows, and to specify the data column and the new pivot value output column.

NoteNote

This topic relies on the Unpivot scenario described in Unpivot Transformation to illustrate the use of the options.

To learn more about the Unpivot transformation, see Unpivot Transformation.

Available Input Columns

Using the check boxes, specify the columns to pivot into rows.

Name

View the name of the available input column.

Pass Through

Indicate whether to include the column in the unpivoted output.

Input Column

Select from the list of available input columns for each row. Your selections are reflected in the check box selections in the Available Input Columns table.

In the Unpivot scenario described in Unpivot Transformation, the Input Columns are the Ham, Soda, Milk, Beer, and Chips columns.

Destination Column

Provide a name for the data column.

In the Unpivot scenario described in Unpivot Transformation, the Destination Column is the quantity (Qty) column.

Pivot Key Value

Provide a name for the pivot value. The default is the name of the input column; however, you can choose any unique, descriptive name.

The value of this property can be specified by using a property expression.

In the Unpivot scenario described in Unpivot Transformation, the Pivot Values will appear in the new Product column designated by the Pivot Key Value Column Name option, as the text values Ham, Soda, Milk, Beer, and Chips.

Pivot Key Value Column Name

Provide a name for the pivot value column. The default is "Pivot Key Value"; however, you can choose any unique, descriptive name.

In the Unpivot scenario described in Unpivot Transformation, the Pivot Key Value Column Name is Product and designates the new Product column into which the Ham, Soda, Milk, Beer, and Chips columns are unpivoted.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft