Hello Community,
I will be glad if someone could help me on this regard, attached is the sample data which I was working and I wanted to update a column in the sample data called Duplicate check. at the moment every line entry is marked as Duplicated record. Now based on the Start date and end date I want to update the Duplicate check column.
To update the Duplicate check column:
in columns Start date and end date the latest date entries in these two columns should be not duplicated records rest of the records will be duplicated records in the Duplicate check column
Sample Data for reference:
| Dups | Start Date | End Date | Duplicate Check |
| abc | 01-Jan-23 | 31-Dec-27 | Duplicated Record |
| abc | 01-Jan-23 | 31-Dec-27 | Duplicated Record |
| abc | 01-May-20 | 30-Apr-23 | Duplicated Record |
| abc | 01-May-20 | 30-Apr-23 | Duplicated Record |
| abc | 01-May-15 | 30-Apr-18 | Duplicated Record |
| abc | 01-May-15 | 30-Apr-18 | Duplicated Record |
| 123 | 01-Aug-19 | 31-Dec-21 | Duplicated Record |
| 123 | 01-Apr-15 | 31-Mar-18 | Duplicated Record |
| 123 | 01-Apr-15 | 31-Mar-18 | Duplicated Record |
| 123 | 01-Jun-24 | 31-Dec-24 | Duplicated Record |
| 123 | 01-Apr-22 | 31-Dec-22 | Duplicated Record |
| xyz | 01-Jan-15 | 15-Dec-17 | Duplicated Record |
| xyz | 01-Jan-15 | 15-Dec-17 | Duplicated Record |
| xyz | 01-Jan-15 | 16-Dec-18 | Duplicated Record |
| xyz | 01-Jan-15 | 16-Dec-18 | Duplicated Record |
| klm | 01-Feb-16 | 31-Dec-20 | Duplicated Record |
| klm | 01-Feb-16 | 31-Dec-20 | Duplicated Record |
| klm | 01-Jan-21 | 31-Dec-24 | Duplicated Record |
| klm | 01-Dec-23 | 30-Nov-27 | Duplicated Record |
| klm | 01-Dec-23 | 30-Nov-27 | Duplicated Record |
