Icon

Row Aggregator, GroupBy and Pivot - Grundgeruest

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

Übungsaufgabe

Pivot
GroupBy
Aufgabe 4
Row Aggregator
Expression
Aufgabe 5
GroupBy
Row Aggregator
Row Filter
Transactions
Table Reader
Column Resorter
Aufgabe 1
Pivot
Pivot
CSV Reader
Column Filter
Aufgabe 2
Pivot
Row Filter
Aufgabe 3.2
Unpivot

Nodes

Extensions

Links