I'd like to remove duplicate records based on ID. For the duplicated record, a check needs to be done in the BRANCH column and retain the record which has the highest value in BRANCH column. I also have unique records so those records should be retained in the output. Please advise
INPUT | |
ID | BRANCH |
AF54WE | 7895433 |
AF54WE | 67548 |
NM765 | 45789 |
HJLN67 | 9887654 |
HJLN67 | 6321 |
YG8790 | 1567 |
YG8790 | 2238865 |
OUTPUT | |
ID | BRANCH |
AF54WE | 7895433 |
NM765 | 45789 |
HJLN67 | 9887654 |
YG8790 | 2238865 |
Solved! Go to Solution.
@Preet2020 try this hope it helps
@Preet2020 One way to do this