Icon

Online Retail-Data Preparation Final

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
Calculates TotalPrice by multiplying Quantity and UnitPrice.
Math Formula
Extracts month and year from InvoiceDate for time analysis.
Date&Time Part Extractor
Aggregates total sales for each country.
GroupBy
Imports the Online Retail dataset into KNIME as the starting point for analysis.
Statistics View
Visualizes total sales by country to compare performance.
Bar Chart
Aggregates total sales by month to identify trends.
GroupBy
Displays monthly sales trend over time.
Line Plot

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-31
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!