Icon

Find Overlaps

Sample DataRow Count addedfor easier comparisonRemove joined rows where this is actually the row beingjoined to itselfDetectoverlapShow just theoverlapsTurn times into a stringso we can turn them intonumbersturn the times intonumbersThe reason for previous two nodes... The TIMEs don't havedates, so if an end time is earlier than a start time we want to add the equivalent of one day to it sowe can compareTidy upthe columnsBring together all rowsfor a given plantTable Creator Counter Generation Rule-basedRow Filter Rule Engine Row Filter Date&Time to String String To Number Math Formula Column Filter Joiner Sample DataRow Count addedfor easier comparisonRemove joined rows where this is actually the row beingjoined to itselfDetectoverlapShow just theoverlapsTurn times into a stringso we can turn them intonumbersturn the times intonumbersThe reason for previous two nodes... The TIMEs don't havedates, so if an end time is earlier than a start time we want to add the equivalent of one day to it sowe can compareTidy upthe columnsBring together all rowsfor a given plantTable Creator Counter Generation Rule-basedRow Filter Rule Engine Row Filter Date&Time to String String To Number Math Formula Column Filter Joiner

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: BATEB031
Created at: 2022-05-04
On NodePit since: 2022-05-05
Last update: 2024-05-01
Created with KNIME version: v4.5.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!