Solution to an exercise for joining and concatenating data.
Join tables with different information for the same ID. Concatenate tables with the same information for different IDs.
CHECK YOUR ANSWERS:
1. The joined table contains 174 rows. Some rows were discarded in the joining operation. This is because not all countries are present or spelled equally in all tables. After editing the names of three countries manually, the joined table contains 177 rows.
2. The Rank column is populated with missing values in the concatenated table when "Use union of columns" is selected
Workflow
07 Join and Concatenate - Solution
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.4.0
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.