Session 3.3.Row Aggregator, GroupBy and Pivot

Pivoting

How many times a product has been purchased in the Online and Onsite stores

• Group by multiple columns

• Apply multiple aggregation methods

• on multiple columns

Basic Data Aggregation

Total quantity per customer

Advanced Data Aggregation

How many times a customer bought a product

This workflow demonstrates different methods to perform data aggregation.

1. Basic Data Aggregation with the Row Aggregator node

2. Advanced Data Aggregation with the GroupBy node

3. Pivoting the table with the Pivot node

Data Aggregation with KNIME:

Row Aggregator, GroupBy and Pivot