The Aggregate transform allows use of aggregate functions such as SUM, AVG, COUNT, MIN, MAX, etc.
For example, the input could be a SQL Select transform that corresponds to the following SQL Server table.
The Aggregate transform requires 1 input transform.
In the Aggregate configuration dialog, you must configure the following settings:
- Select the columns you do want on the output.
- Expand each selected columns and
- Select the Aggregate function, or
- Check the "Group By" checkbox if this column is to be used as a grouping column.
The figure below illustrates the output from the Aggregate transform as applied to the SalesOrderDetails table.