Icon

07 Join and Concatenate

05 Join and Concatenate
The data you gave us was a CSV file and only that file, thusHere is what I did for the course as I can not do this withonly one data file. Exercise: Concatenate1) Execute the Table Reader nodes below. The adult_joined.table file contains the records for all countriesbut Scotland. The records for Scotland are stored in a separate adult_scotland.table file.2) Concatenate the two tables into one3) Which column is missing in one of the tables? If you want to include this column in your concatenatedtable, do you select union or intersection of columns? Read dataadult_income.xlsxRead adult.csvRead adult_education.tableadult_joined.tableadult_scotland.table Concatenate Excel Reader CSV Reader Table Reader Table Reader Table Reader Joiner Joiner The data you gave us was a CSV file and only that file, thusHere is what I did for the course as I can not do this withonly one data file. Exercise: Concatenate1) Execute the Table Reader nodes below. The adult_joined.table file contains the records for all countriesbut Scotland. The records for Scotland are stored in a separate adult_scotland.table file.2) Concatenate the two tables into one3) Which column is missing in one of the tables? If you want to include this column in your concatenatedtable, do you select union or intersection of columns? Read dataadult_income.xlsxRead adult.csvRead adult_education.tableadult_joined.tableadult_scotland.table Concatenate Excel Reader CSV Reader Table Reader Table Reader Table Reader Joiner 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: 2022-02-23
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!