Icon

online_​sales_​dataset

online_sales_dataset.csv taken fromhttps://www.kaggle.com/datasets/yusufdelikkaya/online-sales-dataset
CSV Reader
CustomerIDsplit by '.0'
Cell Splitter
Combining columns with delimiter '-0':1-Year2-Quarter
Column Combiner
Hiding columns:1-ShippingCost2-InvoiceDate-right split
Column Filter
Customer ID
Number to String
CustomerIDInvoiceDate
Column Renamer
Adding CustomerIDprefix 'CUST'
String Manipulation
Removing rowscontaining missingStringsvalues
Interactive Data Cleaning
dataset-EXPORTEDfromKNIME.csv
CSV Writer
Strings
Statistics View
Manual settingProduct>Category
Rule Engine
Right-JoinbyDescription
Joiner
CustomerIDAggregating by:1-Country(UniqueConcatenate)2-Country(UniqueCount)
GroupBy
Left-JoinbyCustomerID
Joiner
Grouping based onInvoiceNumber.Aggregating by:1-InvoiceDate(UniqueConcatenate)2-InvoiceDate(UniqueCount)
GroupBy
Left-JoinbyInvoiceNo
Joiner
Hiding columns:1-Quarter2-StockCode3-OrderPriority4-ShipmentProvider5-UniqueCount(Country)6-UniqueConcatenate(Country)
Column Filter
Numbers & Dates
Statistics View
Hiding columns:1-Year2-InvoiceDate(UniqueCount)
Column Filter
Removing rows containingNEG quantity
Row Filter
Resortingcolumns
Column Resorter
Removing rows whereInvoiceDate(UniqueCount)>1
Row Filter
Grouping by: Description
GroupBy
Grouping by: Category
GroupBy
online_sales_dataset-EXPORTEDfromKNIME.parquet
Parquet Writer
InvoiceDate
String to Date&Time
Adding columnsbased on InvoiceDate:1-Year2-Quarter
Date&Time Part Extractor
InvoiceDatesplit by space
Cell Splitter

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: Gennady
Created at: 2025-09-24
On NodePit since: 2025-10-03
Last update: 2025-10-23
Created with KNIME version: v5.7.0

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

Try NodePit Runner!