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