Sequence based on the last repeated value

[DanielCarro]

Hi guys,

I have a situation  which I am trying to solve but got a bit stuck on it.

So I have the following data:

ID	DATE	SEQ
1	01/01/2025	1
2	02/01/2025	1
2	04/01/2025	2
2	06/01/2025	3
3	05/03/2025	1
4	07/02/2025	1
5	01/03/2025	1
5	03/03/2025	2

My objective is the below in column DATE2:

ID	DATE	SEQ	DATE2
1	01/01/2025	1	01/01/2025
2	02/01/2025	1	06/01/2025
2	04/01/2025	2	06/01/2025
2	06/01/2025	3	06/01/2025
3	05/03/2025	1	05/03/2025
4	07/02/2025	1	07/02/2025
5	01/03/2025	1	03/03/2025
5	03/03/2025	2	03/03/2025

Much appreciated any advice.

Kind Regards,

Dan

[davidskaife · Accepted solution]

Hi @DanielCarro 

Use the Summerize tool to group by ID, and take the Last Date, then join back to the original data on ID. Example workflow attached

[DanielCarro]

Hi @davidskaife 

It worked  perfectly.

Thank you so much