Icon

07 Join and Concatenate

07 Join and Concatenate
Exercise: Concatenate1) Read the life expectancy data from two sources: an Excel sheet that contains the data for countries and adatabase table that contains the data for continents.2) Concatenate them into one table. Use union of columns. What happens to the Rank column that ismissing in the top table? Exercise: Join1) Read the population, life expectancy, geo coordinates, and travel advisories data by executing the readernodes below2) Join all tables based on the names of the countries. Use inner join. How many rows are there in the finaljoined table? Were any rows discarded during the joining operation? Exercise: JoinJoined the Routes and the Airports Tables and excludedirrelevent information. Can now see the name and placeof the destination airport code Demographics.sqliteLifeExpectancydemographics.xlsx(life_expectancy)Detailed Route TableNode 35RoutesAirports SQLite Connector DB Table Selector DB Reader Excel Reader Joiner Concatenate CSV Reader CSV Reader Exercise: Concatenate1) Read the life expectancy data from two sources: an Excel sheet that contains the data for countries and adatabase table that contains the data for continents.2) Concatenate them into one table. Use union of columns. What happens to the Rank column that ismissing in the top table? Exercise: Join1) Read the population, life expectancy, geo coordinates, and travel advisories data by executing the readernodes below2) Join all tables based on the names of the countries. Use inner join. How many rows are there in the finaljoined table? Were any rows discarded during the joining operation? Exercise: JoinJoined the Routes and the Airports Tables and excludedirrelevent information. Can now see the name and placeof the destination airport code Demographics.sqliteLifeExpectancydemographics.xlsx(life_expectancy)Detailed Route TableNode 35RoutesAirportsSQLite Connector DB Table Selector DB Reader Excel Reader Joiner Concatenate CSV Reader CSV Reader

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: 2022-01-24
Last update: 2024-05-01
Created with KNIME version: v4.5.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!