Create an Aggregation in a Data Flow

Insert an aggregation operator to perform SUM, AVG, MIN, MAX, or COUNT calculations.

Procedure

  1. Create a projection operator (see Create a Projection in a Data Flow) and remove all the columns from your dataset except those that you want to aggregate and those that you want to group the aggregations by.
  2. Click the Aggregation tool, drag it onto the diagram canvas, and release it where you want to create the aggregation.
  3. Click and drag the port on the right of the projection operator and drop it onto the aggregation operator.

    A flow is created between the projection and the aggregation operator.

  4. Click the aggregation operator to display its properties in the side panel, and complete the properties in the General section:

    Property

    Description

    Label

    Provide a suitable name for your aggregation as per your requirement.
  5. In the Columns section, review the output columns and set aggregations.
    Hover over a column and click:

    • (Menu)Start of the navigation path Next navigation step Change AggregationEnd of the navigation path to change its aggregation. You can choose:

      • [no value] - Default. Use as grouping column.

      • SUM - [numeric columns only] Calculate the total value of all the rows.

      • AVG - [numeric columns only] Calculate the average value of all the rows.

      • MIN - [numeric columns only] Calculate the minimum value of all the rows.

      • MAX - [numeric columns only] Calculate the maximum value of all the rows.

      • COUNT - Calculate the number of distinct values.

    • (Menu)Start of the navigation path Next navigation step Change NameEnd of the navigation path to change its name.

    • to view its data type.

  6. To complete the aggregation, create a flow from it to the next operator or the target table, as appropriate.