Icon

02_​Data_​Merging

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 1.2 Concatenate the customer data from the two systems 2) Join the information on the online purchases with the prizes of the products 2.1 Join the "TransactionsOnline" and "ProductNrAndPrize" tables directly on the database (DB Joiner) 2.2 Read the joined table into KNIME 3) Add the location information to each purchase in a store based on the StoreID (Joiner node) Connect to DatabaseProduct ID and PriceTransactions OnlineCustomer InformationSystem 1Transactions StoreStore InformationCustomer InformationSystem 2Newsletter to String SQLite Connector DB Table Selector DB Table Selector DB Joiner DB Reader DB Reader File Reader Table Reader Excel Reader (XLS) Joiner Table Reader Concatenate 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 1.2 Concatenate the customer data from the two systems 2) Join the information on the online purchases with the prizes of the products 2.1 Join the "TransactionsOnline" and "ProductNrAndPrize" tables directly on the database (DB Joiner) 2.2 Read the joined table into KNIME 3) Add the location information to each purchase in a store based on the StoreID (Joiner node) Connect to DatabaseProduct ID and PriceTransactions OnlineCustomer InformationSystem 1Transactions StoreStore InformationCustomer InformationSystem 2Newsletter to String SQLite Connector DB Table Selector DB Table Selector DB Joiner DB Reader DB Reader File Reader Table Reader Excel Reader (XLS) Joiner Table Reader Concatenate 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: 2019-12-07
Last update: 2024-04-25
Created with KNIME version: v4.0.2

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

Try NodePit Runner!