Icon

07 Join and Concatenate

07 Join and Concatenate
Exercise: Concatenate1) Read the airplanes data by executing the CSV reader nodes below2) Split the data based on ICAO like A*. Concatenate them back into one table. Use union of columns. Exercise: Join1) Read the airlines, routes, and airports data by executing the CSV reader nodes below2) Join all tables based on the matching keys. Convert string data types to integers. airlines.csvairplanes.csvairports.csvroutes.csvconcatenate lifeexpectancy tablesinner join airlinesand routesNode 39Node 40Node 41ICAO Code like A*ICAO Code not like A* CSV Reader CSV Reader CSV Reader CSV Reader Concatenate Joiner Joiner String To Number String To Number Row Filter Row Filter Exercise: Concatenate1) Read the airplanes data by executing the CSV reader nodes below2) Split the data based on ICAO like A*. Concatenate them back into one table. Use union of columns. Exercise: Join1) Read the airlines, routes, and airports data by executing the CSV reader nodes below2) Join all tables based on the matching keys. Convert string data types to integers. airlines.csvairplanes.csvairports.csvroutes.csvconcatenate lifeexpectancy tablesinner join airlinesand routesNode 39Node 40Node 41ICAO Code like A*ICAO Code not like A* CSV Reader CSV Reader CSV Reader CSV Reader Concatenate Joiner Joiner String To Number String To Number Row Filter Row Filter

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-02
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!