# 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

Thank you!