Forum Discussion
Remove one record and keep one record
Hi Experts
I have a issue where is i have a duplicate in the date column and i want to keep one record and remove the other based on two other columns the other two column are shown in the below sample table. If i sort the data in Power Query By Min Date and Reservation NO. I get the below table, as you can see i have a duplicate in the Date Column. I would like to remove one and keep one by adding a flag column - 0 for unique and 1 for duplicate.
| Date | Min Date | Reservation No |
| 29/03/2021 | 29/03/2021 | RES/00094045 |
| 03/04/2021 | 29/03/2021 | RES/00094045 |
| 02/04/2021 | 29/03/2021 | RES/00094045 |
| 02/04/2021 | 29/03/2021 | RES/00094045 |
| 23/05/2021 | 29/03/2021 | RES/00094045 |
| 02/04/2021 | 29/03/2021 | RES/00094045 |
| 29/03/2021 | 29/03/2021 | RES/00094045 |
Anonymous
is this what you want?
1. group by the table
2. create a flag column
3. remove the count column
1 Reply
Anonymous
is this what you want?
1. group by the table
2. create a flag column
3. remove the count column