Icon

S5-02-Conformity

Preview non-conform records for correction
Table View
HR dataset:1,500 Rows 20 Columns
Excel Reader
Filter out rows with missing values (except termination_date)
Row Filter
Trim spaces for selected columns
String Manipulation (Multi Column)
hire_date Format: yyyy-MM-dd
String to Date&Time
No. missing = 0, except termination_date
Statistics
Create conformity rules per row. (10 rules)
Expression
Create normalized versions(9 rules)
Expression
Count violations across selected columns
Column Aggregator
hire_date Format: dd/MM/yyyy
String to Date&Time
Merge bothparsed columns
Column Merger
Export conforming dataset
Excel Writer
Split records into Comformity (Violation count=0) and Non-Comformity (Violation count>0).
Row Splitter
Keep only original columns
Column 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: Lenovo
Created at: 2026-02-09
On NodePit since: 2026-05-05
Last update: 2026-05-05
Created with KNIME version: v5.8.2

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

Try NodePit Runner!