Icon

KNIME_​overlapping_​date_​range

Find and mark rows for each product thathave overlapping date ranges15/04/2021 @takbb Brian Bates Initial Data SetEffectively "Cross join" where product matchesKeep copy of original rowidIf a row contains date rangeoverlap then mark it as overlapping, provided it's not same original rowid for both datesJoin back to original data setRecover original rowidsRemove rows where not overlapMark as "N" where there is no overlap markedSort on Row IdKeep just 1st rowid and overlap indicatorRemove any duplicated entriese.g. if a row overlaps withmore than one other row Table Creator Joiner RowID Rule Engine Joiner RowID Row Filter Missing Value Sorter Column Filter DuplicateRow Filter Find and mark rows for each product thathave overlapping date ranges15/04/2021 @takbb Brian Bates Initial Data SetEffectively "Cross join" where product matchesKeep copy of original rowidIf a row contains date rangeoverlap then mark it as overlapping, provided it's not same original rowid for both datesJoin back to original data setRecover original rowidsRemove rows where not overlapMark as "N" where there is no overlap markedSort on Row IdKeep just 1st rowid and overlap indicatorRemove any duplicated entriese.g. if a row overlaps withmore than one other rowTable Creator Joiner RowID Rule Engine Joiner RowID Row Filter Missing Value Sorter Column Filter DuplicateRow 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: brian
Created at: 2021-04-15
On NodePit since: 2022-02-06
Last update: 2024-12-26
Created with KNIME version: v4.3.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!