Merge two table using loop
dear KNIME user ,
i have two table
Table 1
Count / Comment/ Start date Time / End Date Time
1 A /2023-11-09 18:15:33/2023-11-09 18:25:48
1 A /2023-11-09 19:40:32/2023-11-09 19:50:38
Table 2
Count / Comment/ Start date Time / End Date Time
11 DA /2023-11-09 18:15:33/2023-11-09 18:18:48
12 CA /2023-11-09 18:18:48/2023-11-09 18:20:48
14 FA /2023-11-09 18:20:48/2023-11-09 18:25:48
11 DA /2023-11-09 19:40:32/2023-11-09 19:42:38
13 CA /2023-11-09 19:42:38/2023-11-09 19:46:38
18 FA /2023-11-09 19:46:38/2023-11-09 19:50:38
OutPut table
Count / Comment/ Start date Time / End Date Time / Remarks
1 A /2023-11-09 18:15:33/2023-11-09 18:25:48 Event
11 DA /2023-11-09 18:15:33/2023-11-09 18:18:48 Reason
12 CA /2023-11-09 18:18:48/2023-11-09 18:20:48 Reason
14 FA /2023-11-09 18:20:48/2023-11-09 18:25:48 Reason
1 A /2023-11-09 19:40:32/2023-11-09 19:50:38 Event
11 DA /2023-11-09 19:40:32/2023-11-09 19:42:38 Reason
13 CA /2023-11-09 19:42:38/2023-11-09 19:46:38 Reason
18 FA /2023-11-09 19:46:38/2023-11-09 19:50:38 Reason
I would like make a output table as shown above using loop node in KNIME. Reason row start time and End time should be within Event row Start time and End time. if this condition not met, then the Remarks column shows Error. Any help greatly appreciated.