GroupBy

Collapses a table into one row per group and totals the numbers, the way a subtotal report does. Pick one or more grouping columns (comma-separated, e.g. Region or Region,Year) and an aggregation; every numeric column outside the group key is aggregated and renamed with a suffix, so Amount summed becomes Amount_Sum.

Inputs

Input	Accepts	Required
`Table`	Table	Yes
`GroupColumns`	Text	Yes
`AggFunction`	Text	Optional

Outputs

Output	Produces
`Result`	Table

Settings

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

Setting	Default	Notes
`AggFunction`	`Sum`	One of Sum, Avg, Count, Min, Max, First, FirstNonNull. Sum through Max apply to every numeric column outside the group key; First and FirstNonNull instead carry all non-key columns through, keeping the first (or first non-blank) value per group.

Example

A Sales table holds 5,000 transactions with Region, Rep, and Amount columns. Group by Region with AggFunction set to Sum, and you get four rows, one per region, with total Amount_Sum for each. The summary appears as its own tab; connect it to a bar chart to compare regions at a glance.

Tips

Count with no numeric columns still works: you get a Count column with the number of rows in each group.
Use First or FirstNonNull to collapse duplicates while keeping text columns (Sum/Avg/Min/Max drop non-numeric columns from the result).