Icon

Date_​between_​Edited_​SF

Check inactive TimeIf the date of one table is between a tim in table two the person is inactive Entry Table1 2018-01-312 2018-02-282 2018-03-312 2018-11-305 2019-02-286 2019-02-287 2019-02-288 2020-01-31Output Table should be1 2018-01-31 02 2018-02-28 12 2018-03-31 12 2018-11-30 15 2019-02-28 06 2019-02-28 17 2019-02-28 18 2020-01-31 1 InactiveDateWorkDateNode 65Node 66Node 67WorkDateInactiveDateNode 405Node 406 Table Creator Table Creator Table Row ToVariable Loop Start Rule Engine Loop End Table Creator Table Creator Joiner Rule Engine Check inactive TimeIf the date of one table is between a tim in table two the person is inactive Entry Table1 2018-01-312 2018-02-282 2018-03-312 2018-11-305 2019-02-286 2019-02-287 2019-02-288 2020-01-31Output Table should be1 2018-01-31 02 2018-02-28 12 2018-03-31 12 2018-11-30 15 2019-02-28 06 2019-02-28 17 2019-02-28 18 2020-01-31 1 InactiveDateWorkDateNode 65Node 66Node 67WorkDateInactiveDateNode 405Node 406 Table Creator Table Creator Table Row ToVariable Loop Start Rule Engine Loop End Table Creator Table Creator Joiner Rule Engine

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: puetz
Created at: 2020-10-12
On NodePit since: 2022-02-06
Last update: 2024-11-17
Created with KNIME version: v4.2.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!