Comparing time according to criteria

[Gabriel2020]

Good afternoon everyone, how are you?

I have a table with the date, Drive Id and time of departure to start collections.

I need to leave if he left SOC once again, but there needs to be a break longer than 30 minutes.

Example :

2024-06-06 | 1170

It has 4 exits, but 2 of them are less than 30 minutes apart.
2024-06-06T14:59:25
2024-06-06T14:59:24

AND

2024-06-06T23:00:51
2024-06-06T23:00:50

Therefore, he needs to compare

2024-06-06T23:00:51
2024-06-06T14:59:25

Because they are the most recent and thus come to the conclusion that it would be longer than 30 minutes and there would be 2 exits.

remembering that there are cases where there are only 2 schedules and in this case you just need to make the comparison.

KNIME_project.knwf (509.4 KB)

[Gabriel2020]

@ArjenEX Can you help me

[Gabriel2020]

I managed to do it by ranking and pulling the minimum and maximum values ​​through Group by.

Later making a Joiner.