Skip to main content Skip to complementary content

Aggregate processor

Aggregates the incoming schema based on one or more columns and performs sets of operations.

The Aggregate processor groups the input flow by aggregation sets which values can be used for calculations in a transformation flow.

Aggregate properties

Properties to configure to aggregate your records.

Configuration
Category name Property name Configuration

Group by

Column path

In the list, select the column you want to use for your aggregation sets.

Operations

Column path

Select the column on which you want to perform a calculation operation.

Operations

Operation

Select the operation you want to apply on your aggregation set: Average, Count, List, Maximum, Minimum, Sum.

Operations

Output column name (optional)

Enter a name for the generated output column. If left empty, the default generated column name will contain the name of the selected column with the name of the selected operation.

The expected format is the following:

  • must begin with [A-Za-z_] characters.
  • can only contain [A-Za-z0-9_] characters.

Example: ASDasd123_4564

To rename the processor, click the EditEdit icon that is displayed when hovering over the default name of the processor.

To edit its description, click the EditEdit icon that is displayed when hovering over Description.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!