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 (Number to String node) 1.2 Concatenate the customer data from the two systems (Concatenate node) 3) Add the store location information to each purchase in a store based on the StoreID (Joiner node) Customer InformationSystem 1Transactions StoreStore InformationCustomer InformationSystem 2 File Reader Table Reader Excel Reader (XLS) Table Reader 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) 3) Add the store location information to each purchase in a store based on the StoreID (Joiner node) Customer InformationSystem 1Transactions StoreStore InformationCustomer InformationSystem 2 File Reader Table Reader Excel Reader (XLS) Table Reader

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-11-17
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!