Grouping dates by periods

Hi all,

I hope you are doing great! :sunny:

I am currently facing an issue with grouping dates by periods. In the attached example, columns A and B contain raw data, which can vary each time, while columns E, F, G, and H display the desired result. I have tried using the GroupBy function with the Worker column, applying First and Last, but this approach misses the gaps in between. Even if the Name and Surname are the same, any gap between the dates should result in two separate rows for the same Worker, as shown in the example.

I have also tried using the Lag function, but it lags into another name and surname, which disrupts my data accuracy. I am hopeful that KNIME can address this issue and would greatly appreciate any assistance you can provide.

Thanks so much! :pray: