Icon

data cleaning

import raw supplier data
Excel Reader
convert Invoice Date tocorrect datatype
String to Date&Time
convert Amountto numeric
String to Number
Country mappingtable with cleanISO codes
Table Creator
replace Countrywith correct values from mapping table
Value Lookup
output:standard report
Workflow Output
top: standard reportbottom: missing values
Row Splitter
Category mappingtable with cleannames
Table Creator
Data cleaninginput frommain workflow
Workflow Input
replace Categorywith correct values from mapping table
Value Lookup
output:errors
Workflow Output

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: User
Created at: 2026-07-10
On NodePit since: 2026-07-17
Last update: 2026-07-17
Created with KNIME version: v5.8.1

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

Try NodePit Runner!