Icon

S5-07-Timeliness

HR data(Rows: 1,000 Columns: 19)
Excel Reader
Service Level Agreement(SLA)
CSV Reader
Split records into Timeliness (Violation count=0) and Lateness
Row Splitter
Attach SLA columnsby source system
Joiner
Create lag time (hours)
Date&Time Difference
Create two timeliness rules
Expression
Split records into Timeliness (Violation count=0) and Lateness
Row Splitter
Keep only original columns
Column Filter
Preview late records for correction
Table View
Preview late records for correction
Table View
Export Timely dataset
Excel Writer
Createtermination update delay (hours)
Date&Time Difference
Case summary
GroupBy
Set time zone for date&time columns
Time Zone Modifier
Filter out rows with missing termination_datedept_transfer_effective_datesalary_effective_date
Row Filter
Case summary
GroupBy
Createsalary update delay (hours)
Date&Time Difference
Createdelay limits(3 constraints)
Expression
Append a time for date columns
Time Modifier
Createdepartment transfer update delay (hours)
Date&Time Difference

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-15
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!