15.3.7 Aggregation

This section provides information about the Aggregation component.

1. Drag and drop the Aggregation component on the canvas to define an aggregation on an EDD or a Catalog Lookup Object.
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. Aggregation component accepts input from an EDD or a Catalog Lookup and it can have only one output.
4. If you have multiple EDDs/ catalog Lookup to be aggregated then you must select as many number of aggregation components, connect each to the respective EDD/ Catalog Lookup, and then define their group by having clauses. Example: To add aggregation to three EDDs or Catalog Lookups, drag three aggregation components on to the canvas and link them to their respective EDDs or Catalog Lookups.
5. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
6. Double-click the Aggregation component to define an aggregation condition. In the Aggregation Window, you will see the selected EDD or Catalog Lookup under the Entities tab. Double click the entities, functions, and operators to build your expression in the Group By field. Repeat this step to build your clause in the Having field.
7. Click Validate to verify the correctness of the SQL Expression.
8. Click Ok.
9. Click Reset to reset all the aggregation conditions and begin afresh.