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 |
