Icon

medshield

1. Data Sources     2. Preprocessing     3. Integration     4. Retail Metrics     5. Analytics     6. Decision

Convert file pathsto text
Path to String
List Files/Folders
Canonicalize andclean fields
Expression
Convert cleaned numeric text
String to Number
Split accepted vs rejects
Row Splitter
Rename to canonical fields
Column Renamer
Merge parsed dates
Column Merger
Assign reject reasons
Rule Engine
Order canonical fields
Column Resorter
Parse d-MMM-yy
String to Date&Time
Hide blank/raw extras
Column Filter
Parse d/M/yyyy
String to Date&Time
Parse M/d/yy
String to Date&Time
dim_area_canonical
Duplicate Row Filter
Quarantinecontract rows
Row Filter
Normalize area andSKU fields
Expression
Join areamapping
Joiner
Read each sales CSV
CSV Reader
Area mappingdictionary
Table Creator
Keep geographicterritories only
Row Filter
Flag contract-likelabels + SKU parts
Expression
Add file metadatacolumns
Variable to Table Column
Extract raw_row_id
RowID
raw_sales_ingest_audit
Loop End
fact_sales_clean
Column Filter
Iterate through 9CSV files
Table Row to Variable Loop Start
dim_sku_canonical
Duplicate Row Filter

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: Ethan
Created at: 2026-08-28
On NodePit since: 2026-08-29
Last update: 2026-08-30
Created with KNIME version: v5.12.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!