CSV Group By & Aggregate
CSV input
Group keys
Column
Resolved
city
Aggregations
Column
Operator
Alias (optional)
Column
Operator
Alias (optional)
Column
Operator
Alias (optional)
Aggregated CSV
Options
Parsing
Output
About Group By & Aggregate
Group rows by one or more columns and compute aggregates such as count, countDistinct, sum, avg, min, and max. Use column names when a header exists, or reference columns by index (#1, c2, 3 for 1-based indexing).
Tips
- Enable Numeric for numeric aggregations to ignore non-numeric values safely.
- Use aliases to control output column names (e.g.,
total_sales). - Switch output delimiter to generate TSV (
\t) or pipe-separated results quickly.