Forum Discussion
Raju223
2 years agoNew Member
How to remove duplicate ID's based on Dates
Hi,
I need to remove dublicate ORS_ID based on the date.
Explaination:- For the perticular date, I want to remove dublicate ORS_ID's present in that date. Same ORS_ID may appear in different date.
Example:- Below snapshot is showing my raw data-
I need to remove highlighed rows only -
As you can see for date 1/3/2023 the id's D2353185804GBJD and D2335215509G543 is dublicate so we need to remove this, Other Id's D2232120200GNY0 and D3004053345GAPB is also dublicate but they are in different date so we have to keep them.
Thanks!!
Raju223 in transform data -> select these two columns -> right click -> remove duplicates.