Summarising on Role to get the start date and end date.

Hi Everyone,

I am new to KNIME. I trying to build a workflow around evaluating the delay in payment of invoices. The Raw data depicts the way the data is in the log file. I would like to grab the first start date associated with the Role and end date associated with the role. For instance, for requisition the start date and time would be 2024-01-01T05:14:02 and end date will be 2024-02-07T20:15:34 showing that the invoice was sitting with requisitioner for 38 days. Then, it went to AP Processor with start date of 2024-02-08T10:14:05 and stayed with him for 2024-03-09T07:21:46 another 28 days. so that I can add them at the end and figure out for how long invoice was sitting with a particular role.

Raw Log

Invoice Number Role Start Date & Time End Date & Time

123 Requisitioner 2024-01-01T05:14:02 2024-01-01T05:14:02

123 Requisitioner 2024-02-06T20:15:30 2024-02-06T20:15:31

123 Requisitioner 2024-02-07T20:15:34 2024-02-07T20:15:34

123 AP Processer 2024-02-08T10:14:05 2024-02-08T10:14:21

123 AP Processer 2024-03-09T07:21:39 2024-03-09T07:21:46

123 Requisitioner 2024-03-25T09:35:19 2024-03-25T09:35:29

123 Requisitioner 2024-04-09T22:22:40 2024-04-09T22:22:43

123 Requisitioner 2024-04-10T07:38:14 2024-04-10T07:38:14

123 AP Processer 2024-05-10T08:23:44 2024-05-10T08:23:46

123 AP Processer 2024-05-10T14:39:12 2024-05-10T14:39:15

Expected output

123 Requisitioner 2024-01-01T05:14:02 2024-02-07T20:15:34

123 AP Processer 2024-02-08T10:14:05 2024-03-09T07:21:46

123 Requisitioner 2024-03-25T09:35:19 2024-04-10T07:38:14

123 AP Processer 2024-05-10T08:23:44 2024-05-10T14:39:15

Appreciated your assistance with the query.