Contents x
    Pivot
    • 26 Jul 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Pivot

    • Updated on 26 Jul 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Description

    The Pivot Node pivots/unpivots data along selected columns.


    Configuration Options

    Basic Configuration Options

    SettingDescription\Parameters
    PivotSetting to either pivot or unpivot the source data set.
    Pivot ColumnColumn to pivot wider on.
    Value ColumnsCorresponding data values to be pivoted with. Each new column will be populated with data from these columns.
    Unpivot ColumnsColumns to condense into a new aggregate/value column.
    Aggregate ColumnName of the new aggregate column in this node's output.
    Value ColumnName of the new value column in this node's output.

    Actions

    ActionDescription
    Refresh Columns from Previous NodeUpdates the Included Columns dropdown list from the parent node.
    PreviewOnce the node is configured, the output, including any exclusions and column data type changes, can be previewed at any time.

    Was this article helpful?
    What's Next