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

[binuacs]

@NiranjanK1 I created a sample workflow based on my understanding, if this is not what you are looking for then provide some input data and expected result

[NiranjanK1]

@binuacs Thanak a lot for quick reply,

same ID, duplicate Date, duplicate number but 

Processing Date will be there for completed events rest will blank, status should be COMPLETED, DB- pending process or pending process and blank, here I have to take highest status for ID based on date, ID number and Event number.

how can I consider all the criteria’s

thanks in advance 

[binuacs]

@NiranjanK1 Group by ID then take the maximum processing date, join back with the actual data with ID and processing date, let me know if you are looking for something else

[NiranjanK1]

@binuacs please have a look at the image,

apologises for the image, as I do not have access to share the data from work location. Some times same ID will have 3 statues 

 

i have share the expected output 

thanks a lot

[binuacs · Accepted solution]

@NiranjanK1 updated workflow attached

[NiranjanK1]

@binuacs thanks for quick response, I can see two entries IDs E_NO_23 for this ID it is already completed I need to show only one row. Kindly help me. Please ignore Sec ID I have added unique numbers, but when ID number duplicated Sec ID also should be duplicate.

[binuacs]

@NiranjanK1 in that case why are you considering E_NO_13 with OS-Pending Process and Process Completed in your ouput result

[NiranjanK1]

@binuacs Actaul dates is different, when we are generating the report ID number randomly allocating, there is chances same ID number will be allocated in different dates. Now please ignore Sec ID column I have not added right data.

[binuacs]

@NiranjanK1 can you try the attached workflow