Icon

join where one date on table 1 between two dates on table 2

Demo of joining where value on t1 is between values on t2

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

transactionsloginslow-codebut more customisableusing hand-written conditiont1."DATE_TIME" between t2."LOGIN_TIME" and t2."LOGOFF_TIME"No CodeJoin where a column value on t1 is between two columns values on t2match all rowsto all rows$DATE_TIME$ >= $LOGIN_TIME$ AND $DATE_TIME$ <= $LOGOFF_TIME$ => TRUECSV Reader CSV Reader Join CustomCondition - indexed Join Between Cross Joiner Rule-basedRow Filter transactionsloginslow-codebut more customisableusing hand-written conditiont1."DATE_TIME" between t2."LOGIN_TIME" and t2."LOGOFF_TIME"No CodeJoin where a column value on t1 is between two columns values on t2match all rowsto all rows$DATE_TIME$ >= $LOGIN_TIME$ AND $DATE_TIME$ <= $LOGOFF_TIME$ => TRUECSV Reader CSV Reader Join CustomCondition - indexed Join Between Cross Joiner Rule-basedRow 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: TQ-11
Created at: 2024-01-22
On NodePit since: 2024-01-23
Last update: 2024-04-28
Created with KNIME version: v4.7.7

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

Try NodePit Runner!