Configure the Aggregation Node
An Aggregation node represents a relational group-by and aggregation operation.
- Double-click the Aggregation node.
Define output columns.
If you have connected the previous node to the Aggregation node, you can map any columns from the input as output columns of the Aggregation node. You can add, delete, and rename the columns, as needed.
In the Mapping pane, select a
Source column and hold and drag the cursor to
the Drop row here zone in the
- (Optional) If you want to automap the columns based on column names, in the Source section, choose (Auto Map by Name).
- If you want to edit a column name, select a Target column and choose (Edit).
If you want to remap an output column with a different source column,
right-click the mapping and choose Remap.
Select a new source column and choose OK.
- In the Mapping pane, select a Source column and hold and drag the cursor to the Drop row here zone in the Target section.
Define the aggregation type.
You can specify the columns that you want to have the aggregate or group-by actions taken upon.
- If you want to define an aggregation type, select a Target column and choose (Edit).
In the Aggregation Type dropdown list, select a
This type is the default aggregation type. You this aggregation type to specify a list of columns for which you want to combine output. For example, group sales orders by date to find the total sales ordered on a particular date.
Calculates the average of a given set of column values.
Returns the number of values in a table column.
Returns the maximum value from a list.
Returns the minimum value from a list.
Calculates the sum of a given set of values.
(Optional) Reorder output columns.
In the Columns tab toolbar, switch to the Form pane to reorder the output columns.
- To reorder the columns, select the column that you want to move and in the toolbar click the up or down arrows.
(Optional) Define filters.
For example, if you want to view the number of sales that are greater than 10000, your expression might look like this: "Aggregation1_input"."SALES" > 10000.
- Select the Filters tab to compare the column name against a constant value.
In the expression editor, enter the required expression.
(Optional) Define SQL HAVING clause.
If you want to retrieve records from the output of a source only when the aggregate values satisfy a defined condition, then:
- Select the Having tab.
- In the expression editor, define the required HAVING condition.
If you want to configure the Data Transform operator with another node,
- In the menu bar, use the breadcrumb navigation to navigate back to the operator configuration editor.
- Add new nodes.
- To connect the nodes, select the output port of a node and drag the cursor to an input port of another node.