Icon

05_​Data_​Manipulation_​optional

Data Manipulation (optional) - Exercise
Exercise 5: Data ManipulationIn this exercise you add a transaction type and merge all data into one table 2a) Join the information of the onsite purchases with the information of 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 secondmetanode)2d) Concatenate the data on online and onsite purchases 3a) Join the transaction andcustomer data on the CustomerID(Hint: Use a right outer join) Top: Online purchasesBottom: Product pricesOne row per basket to one row per product Read data ononline purchases Tabletransformation Read cleanedcustomer information Read onsitetransactions data Resolve StructurProblems in Product Nr Exercise 5: Data ManipulationIn this exercise you add a transaction type and merge all data into one table 2a) Join the information of the onsite purchases with the information of 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 secondmetanode)2d) Concatenate the data on online and onsite purchases 3a) Join the transaction andcustomer data on the CustomerID(Hint: Use a right outer join) Top: Online purchasesBottom: Product pricesOne row per basket to one row per product Read data ononline purchases Tabletransformation Read cleanedcustomer information Read onsitetransactions data Resolve StructurProblems in Product Nr

Nodes

Extensions

Links