Solution

0 ×

Solution to exercise 2 for the KNIME Analytics Platform for Data Wranglers course
- Convert a column from number to string
- Concatenate data from two different sources
- Perform a lookup operation
- Join two database tables (using the DB Joiner node) and read database data into KNIME
- Join two local tables

URL: Slides (KNIME Analytics Platform for Data Wranglers) https://www.knime.com/form/material-download-registration
URL: Concatenate node https://www.youtube.com/watch?v=ku6SyEZ1Pv8
URL: Concatenation https://www.youtube.com/watch?v=VzH2lHbDAg0
URL: What is a Join operation https://www.youtube.com/watch?v=6BigLM6vbhs&feature=youtu.be
URL: The Joiner node https://www.youtube.com/watch?v=9uV99ByH-TA

Nodes

• DB Table Selector (Labs)2 ×
• Table Reader2 ×
• CSV Reader1 ×
• Concatenate1 ×
• Constant Value Column1 ×
• DB Joiner (Labs)1 ×
• DB Reader (Labs)1 ×
• Excel Reader1 ×
• Joiner1 ×
• Number To String1 ×
• SQLite Connector (Labs)1 ×
• Table Creator1 ×
• Value Lookup1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Excel Support

Links

• No links available