Description
The Pivot Node pivots/unpivots data along selected columns.
Configuration Options
Basic Configuration Options
| Setting |
Description\Parameters |
Pivot |
Setting to either pivot or unpivot the source data set. |
Pivot Column |
Column to pivot wider on. |
Value Columns |
Corresponding data values to be pivoted with. Each new column will be populated with data from these columns. |
Unpivot Columns |
Columns to condense into a new aggregate/value column. |
Aggregate Column |
Name of the new aggregate column in this node's output. |
Value Column |
Name of the new value column in this node's output. |
Actions
| Action |
Description |
Refresh Columns from Previous Node |
Updates the Included Columns dropdown list from the parent node. |
Preview |
Once the node is configured, the output, including any exclusions and column data type changes, can be previewed at any time. |