Icon

05_​Data_​Manipulation_​optional

Data Manipulation (optional)

Exercise 5 for the KNIME Analytics Platform for Data Wranglers course
- Create a new feature using the Rule Engine node and the Constant Value Column node
- Concatenate and join different data tables


Exercise 5: Data ManipulationIn this exercise you add a trasaction type and merge all data into one table 2a) Join the information of the onsite purchases with the information of the product prizes (bottomoutput table of the metanode). Exclude columns that were created as intermediate columns in somedata manipulation steps.2b) Create a new column "Type" that gets the value "Store - no CC" if the customer ID is notavailable, and "Store - CC" otherwise.2c) Create a new column "Type" with a constant value "OnlineStore" for the orders coming from theonline store (top output port of the second metanode)2d) Concatenate the data on online and onsite purchases 3a) Join the transaction and customer data onthe CustomerID (Hint: Use a right outer join) Top: Online purchasesBottom: Product pricesOne row per basket to one row per product Read onsitetransactions data Read data ononline purchases TableTransformation Resolve StructurProblems in Product Nr Read cleanedcustomer information Exercise 5: Data ManipulationIn this exercise you add a trasaction type and merge all data into one table 2a) Join the information of the onsite purchases with the information of the product prizes (bottomoutput table of the metanode). Exclude columns that were created as intermediate columns in somedata manipulation steps.2b) Create a new column "Type" that gets the value "Store - no CC" if the customer ID is notavailable, and "Store - CC" otherwise.2c) Create a new column "Type" with a constant value "OnlineStore" for the orders coming from theonline store (top output port of the second metanode)2d) Concatenate the data on online and onsite purchases 3a) Join the transaction and customer data onthe CustomerID (Hint: Use a right outer join) Top: Online purchasesBottom: Product pricesOne row per basket to one row per product Read onsitetransactions data Read data ononline purchases TableTransformation Resolve StructurProblems in Product Nr Read cleanedcustomer information

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-11-16
Last update: 2024-11-18
Created with KNIME version: v4.3.0
Tags: ETLmanipulationjoinmergeeducation

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

Try NodePit Runner!