Icon

02_​Data_​Merging

Data Merging

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






Exercise 2: Join and ConcatenateIn this exercise you combine data by concatenating and joining tables. 1) Concatenate customer information data from the two different systems into one table 1.1 Convert the "Newsletter" column from number to string in the table from the system 1 (Number to String node) 1.2 Concatenate the customer data from the two systems (Concatenate node) 2) Join the information on the online purchases with the prices of the products 2.1 Join the "TransactionsOnline" and "ProductNrAndPrize" tables directly on the database (DB Joiner node) 2.2 Read the joined table into KNIME (DB Reader node) 3) Add the store location information to each purchase in a store based on the StoreID (Joiner node) Connect to DatabaseProduct ID and PriceTransactions OnlineTransactions StoreCustomer InformationSystem 2 Customer InformationSystem 1Store InformationNode 293Node 294Node 295Node 296Node 297Node 298Node 299Node 300Node 301SQLite Connector DB Table Selector DB Table Selector Table Reader Table Reader CSV Reader Excel Reader Joiner DuplicateRow Filter Concatenate Table DifferenceFinder DuplicateRow Filter DB Joiner DB Reader Joiner Number To String Exercise 2: Join and ConcatenateIn this exercise you combine data by concatenating and joining tables. 1) Concatenate customer information data from the two different systems into one table 1.1 Convert the "Newsletter" column from number to string in the table from the system 1 (Number to String node) 1.2 Concatenate the customer data from the two systems (Concatenate node) 2) Join the information on the online purchases with the prices of the products 2.1 Join the "TransactionsOnline" and "ProductNrAndPrize" tables directly on the database (DB Joiner node) 2.2 Read the joined table into KNIME (DB Reader node) 3) Add the store location information to each purchase in a store based on the StoreID (Joiner node) Connect to DatabaseProduct ID and PriceTransactions OnlineTransactions StoreCustomer InformationSystem 2 Customer InformationSystem 1Store InformationNode 293Node 294Node 295Node 296Node 297Node 298Node 299Node 300Node 301SQLite Connector DB Table Selector DB Table Selector Table Reader Table Reader CSV Reader Excel Reader Joiner DuplicateRow Filter Concatenate Table DifferenceFinder DuplicateRow Filter DB Joiner DB Reader Joiner Number To String

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: 2019-10-18
On NodePit since: 2021-06-08
Last update: 2024-04-18
Created with KNIME version: v4.3.3
Tags: ETlconcatenatedatabasejoinpreprocessingeducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!