Forum Discussion

Raju223's avatar
Raju223
New Member
2 years ago
Solved

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.

1 Reply

  • Raju223 in transform data -> select these two columns -> right click -> remove duplicates.