Home > Transforms Nodes > Aggregation > Create Aggregate Node
To define an aggregation, you must identify a data source and columns to aggregate.
Identify or create the node to aggregate. The node can be any node that provides a data flow, including Data Source Nodes.
If the Components window is not open, open it using View > Components. Expand the Transforms section.
Click Aggregate. Move the cursor to the workflow; click again.
Connect the data source to the Aggregate node:
Right-click the data source node; select Connect from the context menu.
Draw a line to the Aggregate node; click again.
Right-click the aggregate node; select Edit. Use the Edit Aggregate Node dialog to define the aggregation.
Right-click the Aggregate node; select Run. Monitor the node execution in the Workflow Jobs. If the Workflow Jobs is not open, open it using View > Data Miner >Workflow Jobs.
After the execution completes, right-click the Aggregate node and select View Data to view the results of the aggregation.