Pivot

Turns a long list into a summary grid: one column supplies the row labels, another supplies the column headers, and a numeric column fills the cells. When several rows land in the same cell, they are combined with the aggregation you choose, the same crosstab a spreadsheet pivot table builds.

Inputs

Input	Accepts	Required
`Table`	Table	Yes

Outputs

Output	Produces
`Result`	Table

Settings

Typed in on the node or set by the assistant, not wired.

Setting	Default	Notes
`RowField`	—	Choose a column from the connected table. Column whose distinct values become the row labels of the result (e.g. LineItem). Required.
`ColField`	—	Choose a column from the connected table. Column whose distinct values become the new column headers (e.g. Year or Month). Required.
`ValueField`	—	Choose a column from the connected table. Numeric column whose values fill the cells. Required.
`AggFunction`	`Sum`	How to combine multiple values landing in the same cell. One of Sum, Avg, Count, Min, Max. Default Sum.

Example

Your Expenses table is a long list with Department, Month, and Amount. Set RowField to Department, ColField to Month, and ValueField to Amount. The result is one row per department with a column for each month: a 12-column spending grid that appears as its own tab. Cells with no matching rows show 0.

Tips

All three of RowField, ColField, and ValueField must be set or the node produces no output.
When the input comes from an Unpivot node, remember its output always has columns named Variable and Value. Use those names here, not the original table's column names.