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
online_sales_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-WarehouseLocation6-UniqueCount(Country)7-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