Group Aggregator Step

Group and aggregate records to consolidate data.

This step is available for standalone plans, embedded plans, and transformation catalog items.

Overview

The Group Aggregator step allows you to group and aggregate data. The step offers quick and easy configuration for simple cases as well as utilizing the full power of ONE expressions for more complex aggregations.

Configuration

This transformation step allows you to group records by one or more attributes and apply aggregate functions to other attributes.

Examples

Example 1: Basic Aggregation by Existing Column

In this example, we aggregate Sales transactions data by reporting_month (a dedicated existing column) and compute maximum, minimum, average value of a transaction in that month as well as sum of all transactions.

Group Aggregator basic configuration showing grouping by REPORTING_MONTH with MINIMUM

Figure 1. Group Aggregator step configuration for basic aggregation

Transformation plan with Group Aggregator step

Data transformation plan showing SP_DT_SALES input connected to Group aggregator step

Example 2: Advanced Aggregation with Expressions

In this example, we aggregate Sales transactions data by a month (which we extract from transaction_date string) and count transactions of type 'SALE' that are larger than $100k.

Group Aggregator step with expression-based grouping and aggregation

Group Aggregator configuration using expressions