Aggregate

Supported in: Batch

Performs the specified aggregations on the input dataset grouped by a set of columns.

Transform categories: Aggregate, Popular

Declared arguments

• Aggregations - List of aggregations to perform on the dataset.
  List<Expression<AnyType>>
• Dataset - Dataset to perform aggregate on.
  Table
• optional Group by columns - List of columns to group the dataset by when aggregating. If empty, no group by is applied.
  List<Column<AnyType>>

Examples

Example 1: Base case

Argument values:

• Aggregations: [
  alias(
   alias: factor,
   expression:
  sum(
   expression: factor,
  ),
  )]
• Dataset: ri.foundry.main.dataset.aggregate
• Group by columns: [tail_number]

Input:

Output:

---