Aggregate

Collects a field from every row into one row.

The opposite of One row per: many rows become one, carrying a list of the collected values. Rows missing the field are skipped. With no field set, rows pass through untouched.

Properties

• Field: the field to collect. Required.
• As: the list field on the one row. Defaults to the field name.

See also: One row per...