Create Aggregation Node

To define an aggregation, you must identify a data source and columns to aggregate.

  1. Identify or create the node to aggregate. The node can be any node that provides a data flow, including Data Source Nodes.

  2. If the Component Palette is not open, open it using View > Component Palette. Expand the Transforms section.

  3. Click Aggregation. Move the cursor to the workflow; click again.

  4. Connect the data source to the Aggregation node:

    1. Right-click the data source node; select Connect from the context menu.

    2. Draw a line to the Aggregation node; click again.

  5. Right-click the aggregation node; select Edit. Use the Edit Aggregation Node dialog to define the Aggregation.

  6. Right-click the Aggregation 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.

  7. After the execution completes, right-click the Aggregation node and select View Data to view the results of the aggregation.