Icon

Session 2.3 How to Join Two Tables

Data Cleaning with KNIME:

How to Join Two Tables

Different join types with the Joiner node — which rows survive when the two tables do not fully match.

Inner join
Left outer join
Full outer join
5 readings: PUMP-01..05
CSV Reader
3 alarms: 02, 05, 09
CSV Reader
inner - only agreements (2)
Joiner
left outer - keep every reading (5)
Joiner
full outer - see both gaps (6)
Joiner

Nodes

Extensions

  • No modules found

Links