Introduction to Aggregating and Pivoting

Data Manipulation in KNIME

Philipp Kowalski

Certified KNIME Trainer

Introduction to Aggregation and Pivoting

an icon image that symbolizes data aggregation

Data Manipulation in KNIME

Introduction to Aggregation and Pivoting

an icon image that symbolizes data aggregation

icons for brain and light bulb - this is a metaphor for easy understanding and analysis

Data Manipulation in KNIME

Introduction to Aggregation and Pivoting

icon showing how data is sent through a funnel for new insights

Data Manipulation in KNIME

Introduction to Aggregation and Pivoting

icon showing how data is sent through a funnel for new insights

icon symbolizing sales, customers and data in general

Data Manipulation in KNIME

Introduction to Aggregation and Pivoting

icon showing a big amount of tabular data

Data Manipulation in KNIME

Introductions to Aggregation and Pivoting

icon showing a big amount of tabular data

icon showing pivoted data

Data Manipulation in KNIME

Simple aggregations with the Row Aggregator

an image of the row aggregator node

Data Manipulation in KNIME

Simple aggregations with the Row Aggregator

a colored table showing sales for April, May and June for different products

Data Manipulation in KNIME

Simple aggregations with the Row Aggregator

a colored table showing sales for April, May and June for different products

another colored table showing the aggregated sales for quarter 2 for different products

Data Manipulation in KNIME

Simple aggregations with the Row Aggregator

an image of the KNIME row aggregator node

Data Manipulation in KNIME

Simple aggregations with the Row Aggregator

an image of the KNIME row aggregator node

 

  • (Occurrence) Count
  • Sum
  • Average
  • Minimum
  • Maximum
Data Manipulation in KNIME

Multi-level aggregations with GroupBy

an image showing the KNIME GroupBy node

Data Manipulation in KNIME

Multi-level aggregations with GroupBy

colored tables showing quarterly sales per region

Data Manipulation in KNIME

Multi-level aggregations with GroupBy

colored tables showing quarterly sales per region

aggregated table of quarterly sales per region

Data Manipulation in KNIME

Multi-level aggregations with GroupBy

icons representing regions, departments and time

Data Manipulation in KNIME

Complex aggregations with the Pivot node

an image of the KNIME pivot node

Data Manipulation in KNIME

Complex aggregations with the Pivot node

an image showing different unstructured data dimensions

Data Manipulation in KNIME

Complex aggregations with the Pivot node

an image showing different unstructured data dimensions

an image showing the same data dimensions but this time structured through the Pivot node

Data Manipulation in KNIME

Complex aggregations with the Pivot node

a screenshot of the configuration of the pivot node with a view on the aggregation methods

Data Manipulation in KNIME

Complex aggregations with the Pivot node

a screenshot of the configuration of the pivot node with a view on the aggregation methods

a screenshot of a resulting pivot table

Data Manipulation in KNIME

Unpivoting data

an image of the KNIME Unpivot node

Data Manipulation in KNIME

Unpivoting data

an icon showing a pivoted table

Data Manipulation in KNIME

Unpivoting data

an icon showing a pivoted table

an icon showing the result of unpivoting as table

Data Manipulation in KNIME

Let's practice!

Data Manipulation in KNIME

Preparing Video For Download...