Icon

07 Join and Concatenate

05 Join and Concatenate

Exercise for joining and concatenating data.

Combine data tables side-by-side using the join operation. Put tables on top of each other with the concatenate operation.

URL: Concatenate: Concatenate node https://youtu.be/ku6SyEZ1Pv8
URL: Concatenate: Piling up Data Tables https://youtu.be/VzH2lHbDAg0
URL: The Join Operation https://youtu.be/1Rqb1jxb86o

Exercise: Joiner 1) Read the adult.csv, adult_education.table, and adult_income.xlsx files by executing the reader nodes 2) Join the adult.csv data with the adult_education.table data. Use the ID column as the joining column. Use inner join. 3) Join the adult_income.xlsx data with the joined table. Apply the same settings. 4) What is the number of rows and columns in the first joined table? And in the second? Were any rows discarded in the joining operations?
Exercise: Concatenate 1) Execute the Table Reader nodes below. The adult_joined.table file contains the records for all countries but Scotland. The records for Scotland are stored in a separate adult_scotland.table file. 2) Concatenate the two tables into one 3) Which column is missing in one of the tables? If you want to include this column in your concatenated table, do you select union or intersection of columns?
Read data adult_income.xlsx
Excel Reader
Read adult_education.table
Table Reader
adult_joined.table
Table Reader
Read adult.csv
CSV Reader
Joiner
Concatenate
adult_scotland.table
Table Reader
Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2026-05-30
Last update: 2026-05-30
Created with KNIME version: v5.11.0
Tags: joinconcatenate

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!