Concatenation, Lookups, and Joins

Data Manipulation in KNIME

Philipp Kowalski

Certified KNIME Trainer

Welcome

Icon representing merging several data sources into one joint dataset

Portrait photo of Philipp Kowalski, instructor for this course

Data Manipulation in KNIME

Welcome

Icons representing merging several data sources and a coach icon

Portrait photo of Philipp Kowalski, instructor for this course

Data Manipulation in KNIME

Welcome

Icons representing merging several data sources and a coach icon and an icon representing awards

Portrait photo of Philipp Kowalski, instructor for this course

Data Manipulation in KNIME

The CFO needs clarity

image representing how different datasources can be merged into one report using KNIME as an automation tool

Data Manipulation in KNIME

Concatenating tables

icons for different tables representing different months

Data Manipulation in KNIME

Concatenating tables

icons representing different regional tables that need to be merged together

Data Manipulation in KNIME

Concatenating tables

icons representing different regional tables that need to be merged together

icon representing the finally merged table

Data Manipulation in KNIME

Simple lookups

icon of the Value Lookup node in KNIME

Data Manipulation in KNIME

Simple lookups

  • Enrich data
  • Differing table structures

icons for two different tables

Data Manipulation in KNIME

Simple lookups

icon for the transactions table without key highlighted

icon for the products table without key highlighted

Data Manipulation in KNIME

Simple lookups

icon for the transactions table with the product ID column as key highlighted

icon for the products table with the product ID column as key highlighted

Data Manipulation in KNIME

Merging with Joins

icon for the Joiner node in KNIME

Data Manipulation in KNIME

Merging with Joins

Inner Join icon with a Venn diagram representing an inner join

Data Manipulation in KNIME

Merging with Joins

Inner Join icon with a Venn diagram representing an inner join

Left Outer Join icon with a Venn diagram representing a left outer join

Data Manipulation in KNIME

Merging with Joins

Inner Join icon with a Venn diagram representing an inner join

Left Outer Join icon with a Venn diagram representing a left outer join

Right Outer Join icon with a Venn diagram representing a right outer join

Data Manipulation in KNIME

Merging with Joins

Inner Join icon with a Venn diagram representing an inner join

Left Outer Join icon with a Venn diagram representing a left outer join

Right Outer Join icon with a Venn diagram representing a right outer join

Full Outer Join icon with a Venn diagram representing a full outer join

Data Manipulation in KNIME

Let's practice

Data Manipulation in KNIME

Preparing Video For Download...