tell me more icon Aggregation

SH.SALES contains information about individual sales. We need to transform this data into a nested table with total sales and total profits per customer. For each customer, we also want total sales and total profits for each product.

To calculate total quantity sold (the total number of items sold to a customer), add all values of QUANTITY_SOLD for each customer. To calculate total amount sold (the total amount of money paid by a customer), add all values of AMOUNT_SOLD for each customer.

In other words, we need to aggregate these values on a per customer basis. We do this using an Aggregate transform.

In the Aggregate node, specify PROD_ID as a Sub Group By column; the Aggregate node then create a nested table that can be used for data mining.