Removing duplicates based on ID, Status and date

[NiranjanK1]

Hi All,

I need a help to remove duplicates based on event is having multiple statuses for same IDs, I need to take highlighest status, if ID has completed status I need take same status and remove duplicates based on Status, actual date, ID number and processing date

please suggest me

 

thanks in advance,

NR

[NiranjanK1]

@binu_acs working as expected thanks a lot