Aggregate framework

Use this framework to combine several rows into one in the target table. The objective is to extract the set of values, transform it and send the result to the target table.

1. From the window called Adding tables to the model, select Aggregate in the list.
2. Select the table(s) and click Ok.
3. Use the wizard to retrieve and manipulate columns: drag and drop them from the left part to the right part of the screen.
   There are three categories:

   • GROUP BY: choose at least one column to group column values together.
   • SELECT: if needed, add non-aggregated columns to the final result.
   • AGGREGATE: add columns to return values transformed through an aggregation process (sum or count).
   
   In the example above, all columns are grouped according to the product key one.
   We want to answer the following questions:
   • How many customers are there?
   • How many sale transactions were made?
   • What is the total amount of sales?
4. Click Go when the selection of columns is complete.
   In the table properties, the selected columns are now aggregated:
   
5. If needed, use the Transformation and selection tool to check the aggregations added, to edit them or to add a lookup.