Home > Transforms Nodes > Aggregation > Edit Aggregate Node > Define Aggregation
This wizard defines aggregations. Follow these steps:
First define the Function to use for aggregation. Available functions depend on the data type of the column that you are aggregating. For example, you can select SUM if you plan to aggregate one or more columns of numerical values.
Click Next.
Select one or more Columns to aggregate. You must select columns with a data type compatible with the function that you selected. For example, if the function is SUM, you must select columns that have numerical data types.
Click Next.
Optionally, select a Sub-Group By column for aggregation. Specifying a Sub-Group By column creates a nested table. For example, you could use sub-group by to calculate amount sold per product per customer. The nested table contains columns with data type DM_NESTED_NUMERICALS.
You can select a Sub Group By expression by changing Type to Expression. If you define an Expression, click Validate to validate the expression.
Click Next.
Review the default names for the columns. You can change the names.
Review the definitions if necessary. You can click Back to make changes.
Click Finish when you are done.