Transform nodes

Transform nodes reshape the table as a whole rather than row by row: they group rows, pivot them wide, or unpivot them tall.

Pivot rows into a wide cross-tabulation.

Group by one or more columns and compute aggregate values: sum, average, count, median and more.

Unpivot wide columns into tall Name/Value rows (the inverse of Cross Tab).