Icon

05_​Data_​Manipulation_​optional

Exercise 5: Data ManipulationIn this exercise you add a trasaction type and merge all data into one table 2a) Join the information on the onsite purchases with the information on theproduct prizes (bottom output table of the metanode). Exclude columns thatwere created as intermediate columns in some data manipulation steps.2b) Create a new column "Type" that gets the value "Store - no CC" if thecustomer ID is not available, and "Store - CC" otherwise.2c) Create a new column "Type" with a constant value "OnlineStore" for theorders coming from the online store (top output port of the metanode)2d) Concatenate the data on online and onsite purchases 3a) Join information on customerswith the purchase information Add transaction typeAdd type transaction typeAdd Prizeand exclude superflous columnsTop: Online purchasesBottom: Product prizesOne row per basket to one row per product ConstantValue Column Rule Engine Read onsitetransactions data Joiner Concatenate Joiner Read cleanedcustomer information Read data ononline purchases Tabletransformation Resolve structureproblems in Product Nr Exercise 5: Data ManipulationIn this exercise you add a trasaction type and merge all data into one table 2a) Join the information on the onsite purchases with the information on theproduct prizes (bottom output table of the metanode). Exclude columns thatwere created as intermediate columns in some data manipulation steps.2b) Create a new column "Type" that gets the value "Store - no CC" if thecustomer ID is not available, and "Store - CC" otherwise.2c) Create a new column "Type" with a constant value "OnlineStore" for theorders coming from the online store (top output port of the metanode)2d) Concatenate the data on online and onsite purchases 3a) Join information on customerswith the purchase information Add transaction typeAdd type transaction typeAdd Prizeand exclude superflous columnsTop: Online purchasesBottom: Product prizesOne row per basket to one row per product ConstantValue Column Rule Engine Read onsitetransactions data Joiner Concatenate Joiner Read cleanedcustomer information Read data ononline purchases Tabletransformation Resolve structureproblems in Product Nr

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!