Aggregation is a data preparation task frequently used to reduce the size of a dataset. Before proceeding with aggregation, you should take time to clean the data, concentrating especially on missing values. Once you have aggregated, potentially useful information regarding missing values may be lost.
You can use an Aggregate node to replace a sequence of input records with summary, aggregated output records. For example, you might have a set of input sales records such as those shown in the following table.
You can aggregate these records with
Region as key fields. Then choose to aggregate
Age with the mode
Sales with the mode Sum.
Select the Include record count in field aggregate node option and your
aggregated output will be similar to the following table.
|Age (mean)||Sex||Region||Sales (sum)||Record Count|
From this you learn, for example, that the average age of the four female sales staff in the North region is 35.5, and the sum total of their sales was 25 units.
Branchare automatically discarded when no aggregate mode is specified.