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
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.