Icon

KNIME_​ETL

Decompressed succesfully. Files with different extensions, not available in the current workflow. Solution: read separately

DATA READING

DATA CLEANING

DATA TRANSFORMATION

DATA PRE-PROCESSING METANONDE

DATA MERGING

DATA AGGREGATION

Decompress Files
Table Row to Variable
CSV Reader
Clients: System 1
Excel Reader
Clients: System 2
Table Reader
Stores
CSV Reader
Sales
SQLite Connector
Age group binning(dzielenie na koszyki)
Expression
Basket Size and Value
GroupBy
Country name "_" out
Expression
Pivot Count with Store Type
Pivot
Join on "CustomerID"
Joiner
Aggregate Clients Price SUM
Row Aggregator
Select optimal email
Column Merger
Product number to string
Number to String
Products by store type
Bar Chart
Split Customer ID by "_"
Cell Splitter
Client Info + Product Summary
GroupBy
Name split results
Column Renamer
Put ID up front
Column Resorter
Access: Products and Price
DB Reader
Select table: Products and price
DB Table Selector
DATA PREPROCESSING
Report PDF Writer
Select table: Transactions
DB Table Selector
Remove: Row 1
Table Cropper
Join: Add Store Type to Transactions
Value Lookup
Access: Transactions
DB Reader
Report Template Creator
Filtered out: 'Column'
Column Filter
Column email: remove " " and replace with ""
Expression
REPORT
Age: missing to column median
Missing Value
Check for duplicates
Duplicate Row Filter
Filter out: Age (improbable)
Row Filter
Remove all empty rows (Cropper alternative)
Remove Empty Rows
Join: Add Price to Transactions
Value Lookup
Remove duplicates: 'Customer ID'
Duplicate Row Filter
Connect: Client1 + Client2
Concatenate

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: barto
Created at: 2025-10-07
On NodePit since: 2025-10-08
Last update: 2025-10-28
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!