Pivot Node

Description

Use the Pivot node to summarize the relationship between two columns. To build a pivot table, you'll need to specify the two columns to compare:

Options

Pivot index: the vertical axis of the pivot table
Pivot column: the horizontal axis of the pivot table
Pivot value: the metric to summarize
Aggregation method: how to aggregate the pivot value, e.g. COUNT, SUM, MAX, AVERAGE, etc.

Tips

For best results, you can only summarize by a single metric. If you need to summarize multiple metrics, utilize the Group and Aggregate node instead.
The output will show the relationship of each unique combination of the two columns, in a 2D layout.

SQL Equivalent

select {pivot_index}
from {data_source}
pivot (
    SUM({pivot_value}) for [pivot_column]
)

↩️ Back to Workflow Settings

Updated on: 05/10/2024