These steps are part of the larger task of Grouping related data from selected columns into a single column. When you complete these steps, click the link at the bottom of the page to return to the main task.
To specify the data groups and pivot groups for a pivot column:
On the Parameters page of the Pivot Data transformer notebook, click Advanced. The Pivot Data Transformer - Advanced window opens.
Use the table in this window to define your pivot groups. 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.
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 group columns 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. You must select a column for each field in a pivot group.
Click OK. The Pivot Data Transformer - Advanced window closes.
If you make changes to the selected pivot columns in the Pivot Data Transformer window, the data group and pivot group values that you specified in this window will be reset to blank.
Return to Grouping related data from selected columns into a single column.