Data Manipulation - Solution

Solution to the exercise 2 for KNIME User Training
- Concatenate data from two different sources
- Bring values from a reference table to the actual table using the Cell Replacer node
- Modify String values
- Join data from multiple tables
- Remove duplicates in the data

External resources

• Advanced ETL Functionalities and Machine Learning based Pre-Processing
• Joining Data Tables
• Joining Data Tables - Inner Join
• Concatenate
• Concatenate Node
• Data Manipulation: Numbers, Strings, and Rules
• Slides (KNIME Analytics Platform Course)