Icon

exercises

Pt 1. Data Import and Cleanup

Pt.2

Pt 3.

Pt 4.

Fix Name

Group 1: Date and Time

Group 3: Flow Variables

Group 3: Flow Variables - Using Components

Group 6

Split address intocomponents
Cell Splitter
Component
Rename addresscomponents tobe more readable
Column Renamer
Expression
Replace the dotwith a space.Capitalise eachword/name
Expression
Column Renamer
Split on comma
Cell Splitter
Split on @ character
Cell Splitter
Transactions B
CSV Reader
All transactions
Concatenate
Account master
CSV Reader
Transactions A
CSV Reader
Component
Joiner
Monthly expenses
CSV Reader
Value Lookup
CSV Writer
CSV Reader
Row Aggregator
GroupBy
CSV Reader
Color Manager
Scatter Plot
Expense report
Excel Reader
Filter whereamount is greaterthan 500
Row Filter
Remove weirdcharacters fromamounts
Expression
Convert the stringamount to number
String to Number
Remove "notes"column
Column Filter
Missing Value
Date&Time Part Extractor
String to Date&Time (deprecated)
Date&Time-based Row Filter
Top port: Structured date formatsBottom: Free-text date formats
Row Splitter
Unify date formats
Expression
Transaction Log
CSV Reader
Replace allslashes with dashesin the transactiondate
Expression
Without AI, convertto common format
Expression
Split transactiondate on the dash
Cell Splitter
String to Date&Time (deprecated)
Table Row to Variable
String to Number
Filter by Min Amountparameter (flow variable)
Row Filter
Report Parameters
CSV Reader
Sales Transactions
CSV Reader
Uniqueness on employeeID
Duplicate Row Filter
Overdue on topport
Row Splitter
Sales Transactions
CSV Reader
group2Invoice Aging
CSV Reader
Sort overduesby days overdue
Sorter
Filter out invalidamounts
Missing Value
Filter by selectedregion
Row Filter
Top port: Invalid amountBottom port: Valid
Row Splitter
Report Parameters
CSV Reader
CSV Reader
Clean up vendor code
Expression
Commissioncalculation
CSV Reader
Expression

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: jacobcoles
Created at: 2025-11-03
On NodePit since: 2026-06-25
Last update: 2026-06-26
Created with KNIME version: v5.4.4

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

Try NodePit Runner!