Icon

04_​Data_​Transformation_​Exercise

Data Transformation - Exercise

Exercise 4 for the KNIME Analytics Platform for Data Wranglers course
- Transform a data table with the Unpivoting node and remove superfluous rows and columns
- Format a string value using a combination of different manipulation nodes, e.g. Cell Splitter, Row Splitter, and String Manipulation





Exercise 4: Table RestructuringIn this exercise you change data structure by unpivoting columns to rows. 1) Change the structure of the table with the onsite purchases so that each purchased productis in a separate row and not the whole purchase event 1.1 Unpivot the columns that show the products ordered in one purchase event.Retain other columns in the table. 1.2 Remove rows that have missing values for the unpivoted column values 1.3 Rename "ColumnValues" column to "ProductNr" and "ShoppingNumber" to"OrderNumber" 1.4 Remove unnecessary columns "BasketSize" and "ColumnNames"Hint: combine tasks 1.3 and 1.4 using a single Table Manipulator node 2) (optional) Format the product numbers 2.1 Split the product numbers into substrings where separated by "-" 2.2 Convert the middle part to string and padLeft with zeros to create a 3-char code 2.3 Combine the manipulated substrings back to one string, and replace the productnumbers by these manipulated values Read onsitetransactions data Exercise 4: Table RestructuringIn this exercise you change data structure by unpivoting columns to rows. 1) Change the structure of the table with the onsite purchases so that each purchased productis in a separate row and not the whole purchase event 1.1 Unpivot the columns that show the products ordered in one purchase event.Retain other columns in the table. 1.2 Remove rows that have missing values for the unpivoted column values 1.3 Rename "ColumnValues" column to "ProductNr" and "ShoppingNumber" to"OrderNumber" 1.4 Remove unnecessary columns "BasketSize" and "ColumnNames"Hint: combine tasks 1.3 and 1.4 using a single Table Manipulator node 2) (optional) Format the product numbers 2.1 Split the product numbers into substrings where separated by "-" 2.2 Convert the middle part to string and padLeft with zeros to create a 3-char code 2.3 Combine the manipulated substrings back to one string, and replace the productnumbers by these manipulated values Read onsitetransactions data

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: 2023-01-24
Last update: 2024-05-01
Created with KNIME version: v4.7.0
Tags: table restructuringunpivotingETLmanipulationeducation

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

Try NodePit Runner!