Use this window to specify a pivot group and a data group for each pivot column that you selected in the Pivot Data Transformer window.
The number of rows that are displayed in this table depend on the number of pivot columns that you selected and the number of pivot groups that you specified on the Parameters page. For example, If you selected 6 pivot columns and 2 pivot groups, 3 rows are displayed.
To specify a pivot group and a data group for each pivot column:
Click the Data group field. Then, type a name for a data group. A data group is a column in the target table. This column is used to describe or label information that is collected into pivot groups so that the original meaning of the data as expressed by the column labels in the input table is preserved in the output table. If you leave this field blank, and there is only one pivot group, the names of the pivot columns are pivoted into the data fields of the output column that results when the step is run.
Select a pivot column for each pivot group. The number of pivot groups that are displayed in this table is the same number of pivot groups that you specified on the Parameters page. To select a pivot column, double-click the Pivot group field and select a column. You cannot select a column for more than one pivot group.
Click OK. The Pivot Data Transformer - Advanced window closes.