Removing duplicates based on ID, Status and date

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,

Developer

Developer Tools

Best Practices

Spatial Analysis

Interface Tools

Data Investigation

Database Connection

Behavior Analysis

Accepted answers

binu_acs

@NiranjanK1 updated workflow attached

Status_17072025Updated.yxzp

All comments

binu_acs

@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

Status_17-72025.yxmd

NiranjanK1

@binu_acs 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

binu_acs

@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

Status_17-72025.yxmd

NiranjanK1

@binu_acs 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

binu_acs

@NiranjanK1 updated workflow attached

Status_17072025Updated.yxzp

NiranjanK1

@binu_acs 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.

binu_acs

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

NiranjanK1

@binu_acs 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.

binu_acs

@NiranjanK1 can you try the attached workflow

Status_17072025Updated.yxzp

NiranjanK1

@binu_acs working as expected thanks a lot

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335