Group by consectuive Lines and get latest timestamp

[listale]

I have the following Demo Dataset:

RecordID	Process	Timestamp	Recipe
1	Inlay	07.12.2021 07:54	A
2	Suspension	07.12.2021 07:54	A
3	Suspension	07.12.2021 08:09	A
4	Suspension	07.12.2021 09:29	A
5	Release	07.12.2021 09:31	A
6	Manual Entry	07.12.2021 09:40	A
7	Suspension	08.12.2021 05:10	A
8	Suspension	08.12.2021 05:12	A
9	Inlay	08.12.2021 06:00	B
10	Inlay	08.12.2021 07:00	B
11	Inlay	08.12.2021 07:30	B
12	Suspension	08.12.2021 08:00	B
13	Release	08.12.2021 09:00	B
14	Manual Entry	08.12.2021 10:00	B

What I´m trying to achieve:

Group all same Rows based on column Process which are consectuive (same Process-Name can appear multiple times -> f.e. Suspension on RecordID 2,3,4 and 7,8)

And within each group only keep the last timestamp.

Desired Output would be:

RecordID	Process	Timestamp	Recipe
1	Inlay	07.12.2021 07:54	A
4	Suspension	07.12.2021 09:29	A
5	Release	07.12.2021 09:31	A
6	Manual Entry	07.12.2021 09:40	A
8	Suspension	08.12.2021 05:12	A
11	Inlay	08.12.2021 07:30	B
12	Suspension	08.12.2021 08:00	B
13	Release	08.12.2021 09:00	B
14	Manual Entry	08.12.2021 10:00	B

Any ideas how to achieve this with Alteryx ?

Thanks in advance for any help

[atcodedog05 · Accepted solution]

Hi @listale 

Here is how you can do it.

Workflow:

Hope this helps : )

[listale]

Great, works flawless thanks alot @atcodedog05

[atcodedog05]

Happy to help : ) @listale 

Cheers and have a nice day!

[Qiu · Accepted solution]

@listale 
We can do something like this.

[listale]

also works, thanks @Qiu

[Qiu]

@listale 
Glad to help and thank you for the accept mark. 😁