Icon

Online Retail-Data Preparation

Reads the Online Retail dataset from a CSV file into KNIME as the starting point for data preparation.
CSV Reader
Filters out rows with missing or invalid values to improve data quality before further processing.
Row Filter
Removes duplicate transaction records to prevent double-counting and ensure accurate analysis.
Duplicate Row Filter
Creates a new derived column called TotalPrice by multiplying Quantity and UnitPrice to represent total transaction value.
Math Formula
Converts the InvoiceDate column from string format into a proper Date&Time format for time-based analysis
String to Date&Time
Removes irrelevant or unused columns to simplify the dataset and focus on important attributes for analysis.
Column Filter

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: arthi
Created at: 2026-01-28
On NodePit since: 2026-01-29
Last update: 2026-02-07
Created with KNIME version: v5.8.1

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

Try NodePit Runner!