Icon

Chapter 3 - Ecommerce

Keep top 10 only
Row Filter (deprecated)
Read transactions L3M
Excel Reader
For each subcategory
Group Loop Start
Sort by decreasing sales
Sorter
Exclude 'Others' category
Row Filter (deprecated)
Read transactions History
Excel Reader
Convert dates
String to Date&Time (deprecated)
Keep top 3 only
Row Filter (deprecated)
Loop End (deprecated)
Read Customer MD
CSV Reader
Aggregate by category and month
Pivot
Sort by decreasing sales
Sorter
Aggregate by country
GroupBy
Left outer join on customers
Joiner
Manage missing values
Missing Value
Saves chart image
Image Writer (Port)
Save report
Excel Writer
Extract months
Date&Time Part Extractor
Inner join on products
Joiner
Read product MD
CSV Reader
Concatenate transactions
Concatenate
Convert ID to string
Number to String
Aggregate by product
GroupBy
Aggregate by Category
GroupBy
Only for 2019
Date&Time-based Row Filter
Create variable with total
Table Row to Variable
Calculate sales
Math Formula
Calculate total sales
GroupBy
Visualize sales by month
Line Plot (JavaScript) (legacy)
Calculate footprint
Math Formula

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: demauro.a
Created at: 2021-01-10
On NodePit since: 2026-07-28
Last update: 2026-08-02
Created with KNIME version: v5.8.3

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

Try NodePit Runner!