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