Skip to main content

​
What This Node Does

The Pivot node reshapes data from long format (narrow, many rows) to wide format (wide, fewer rows) by converting row values into column headers. Use it to create crosstab reports, summary tables, or transform normalized data for analysis and visualization. [SCREENSHOT: Pivot node showing transformation from long format (1000 rows × 3 columns) to wide format (100 rows × 12 columns)]

​
When to Use This Node

Use the Pivot node when you need to:
  • Create crosstab reports - Convert sales data (Region, Month, Sales) into Region × Month matrix
  • Build summary tables - Transform transaction log into customer × product purchase matrix
  • Compare across categories - Create Product × Quarter revenue comparison table
  • Prepare for heatmaps - Reshape data for heatmap visualization (rows × columns)

​
Step-by-Step Usage Guide

1

Add Pivot node to canvas

2

Connect to input data

3

Select Group By columns

Choose columns that define output rows (e.g., Region). Each unique combination creates one output row.[SCREENSHOT: Group By column selector]
4

Select Pivot column

Choose the column whose values become new column headers (e.g., Month)[SCREENSHOT: Pivot Column dropdown with “Month” selected]
5

Select Values column

Choose the column with values to fill pivoted cells (e.g., Sales)[SCREENSHOT: Values Column dropdown]
6

Choose aggregation function

Select SUM, AVG, COUNT, MIN, MAX, FIRST, or LAST for combining values[SCREENSHOT: Aggregation dropdown with SUM selected]
7

Preview results

​
Tips and Best Practices

Limit Pivot Values: Keep pivot column unique values < 100. Too many unique values create extremely wide, hard-to-read tables.
Check Aggregation: Verify aggregation function matches your data. SUM for totals, AVG for rates, COUNT for frequencies.
Preview First: Use Distinct node on Pivot Column to see how many new columns will be created before pivoting.
Sort Before Pivot: Use Sort node before Pivot to control FIRST/LAST aggregation results when row order matters.
Unpivot Reverse: To reverse pivot operation, use Unpivot node to convert wide format back to long format.