Icon

overlapping_​absence

Node 8start dateleeve only start dateleeve only end dateend date (fill missing)remove duplicated dates on the basis of most recent absence IDderive end date (before the next interval starts)duration bewtween start dates per absence idNode 28remove duplicated dates on the basis of most recent absenceremove duplicated dates on the basis of most recent absence IDmax end date for the entire intervall (all absences)add max end date column (to close the entire interval)Node 37Node 38Node 39Node 403-way check datesmax start date for the entire intervall (all absences)add max start date column (to do a 3-way checkto decide which date should be the end-date)final resultNode 45Timestamp Alignment String to Date&Time Missing Value Timestamp Alignment Column Filter Column Filter Missing Value DuplicateRow Filter Date&Time Shift GroupBy Joiner DuplicateRow Filter DuplicateRow Filter GroupBy Cross Joiner Table Row toVariable Loop Start Loop End DuplicateRow Filter Row Filter Rule Engine GroupBy Cross Joiner Column Filter Table Creator Node 8start dateleeve only start dateleeve only end dateend date (fill missing)remove duplicated dates on the basis of most recent absence IDderive end date (before the next interval starts)duration bewtween start dates per absence idNode 28remove duplicated dates on the basis of most recent absenceremove duplicated dates on the basis of most recent absence IDmax end date for the entire intervall (all absences)add max end date column (to close the entire interval)Node 37Node 38Node 39Node 403-way check datesmax start date for the entire intervall (all absences)add max start date column (to do a 3-way checkto decide which date should be the end-date)final resultNode 45Timestamp Alignment String to Date&Time Missing Value Timestamp Alignment Column Filter Column Filter Missing Value DuplicateRow Filter Date&Time Shift GroupBy Joiner DuplicateRow Filter DuplicateRow Filter GroupBy Cross Joiner Table Row toVariable Loop Start Loop End DuplicateRow Filter Row Filter Rule Engine GroupBy Cross Joiner Column Filter Table Creator

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: AdamR
Created at: 2024-08-10
On NodePit since: 2025-02-08
Last update: 2025-04-03
Created with KNIME version: v5.3.3

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

Try NodePit Runner!