Dates

[Ayaanarjun-5885]

Hi, I have some data with Records and dates. Now I want to extract the data from only last 2 dates and so that I can analyze whether the records are repeated or not based on last 2 dates. As per the below I can analyze ""I" is repeated on both the dates then I'll another column and I'll mark it as "Yes" as it is repeated. Could you please provide the solution for below

Input:

Record	Dates
A	10/29/2023
B	10/29/2023
C	10/29/2023
D	10/31/2023
A	10/31/2023
F	10/31/2023
D	10/31/2023
D	11/1/2023
I	11/1/2023
J	11/1/2023
I	11/4/2023
L	11/4/2023
I	11/6/2023
J	11/6/2023
O	11/6/2023

Output:

Record	Dates	Repeated or not
I	11/4/2023
L	11/4/2023
I	11/6/2023	Yes
J	11/6/2023	No
O	11/6/2023	No

[messi007 · Accepted solution]

@Ayaanarjun-5885,

Please see below how you can do that.

Attached the workflow.

Hope this helps!

Regards,