Icon

20211204 Pikairos Joining two tables based on date ranges

There has been no description set for this workflow's metadata.

Drive EventCar ScheduleIf you have Millions of lines& to make thingsmore efficient,deal with Joiningbased on Separate CarsGet UniversalTime Stampfor 1st Date&TimeGet UniversalTime Stampfor 2nd Date&TimeConcatenateall the resultsJoin2nd Table based onCurrent CarGet Time Stampfor Drive Date&TimeCheck Interval TimesJust neededfor easingdates visualizationin theirchronological orderFilter OUTTimeStampsExcel Reader Excel Reader Group Loop Start Date&TimeDifference Date&TimeDifference Loop End Joiner Date&TimeDifference Rule-basedRow Filter Sorter Column Splitter Drive EventCar ScheduleIf you have Millions of lines& to make thingsmore efficient,deal with Joiningbased on Separate CarsGet UniversalTime Stampfor 1st Date&TimeGet UniversalTime Stampfor 2nd Date&TimeConcatenateall the resultsJoin2nd Table based onCurrent CarGet Time Stampfor Drive Date&TimeCheck Interval TimesJust neededfor easingdates visualizationin theirchronological orderFilter OUTTimeStampsExcel Reader Excel Reader Group Loop Start Date&TimeDifference Date&TimeDifference Loop End Joiner Date&TimeDifference Rule-basedRow Filter Sorter Column Splitter

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: Molina
Created at: 2021-12-03
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.4.1

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

Try NodePit Runner!