Remove both duplicate values, not just the later one

Hello,

I am looking for a way to remove rows that contain duplicate employee ID numbers. I don't want to just show the unique values, but instead delete any row that has a duplicate (removing a pair of duplicates, not just the later duplicate value). Is there any way to do this?

My desired output is just the employee ID numbers that have not been duplicated. I pulled a report retroactively and one in the present say, so I am looking to find the rows that show up in one report but not the other (bidirectional).

Best Practices

Accepted answers

I'd use the summarize tool to group and count on EmployeeID then you can filter on Count = 1

Remove Duplictaes.PNG

Remove Duplicates.yxmd

All comments

this can be doing using the attached workflow.

within there I have used one of the CREW macros to help, this can return a true distinct rather than 1 of the duplicates

Kind regards

Shaan

TrueUnique.yxzp

I'd use the summarize tool to group and count on EmployeeID then you can filter on Count = 1

Remove Duplictaes.PNG

Remove Duplicates.yxmd

This is great thank you for the quick reply!

Is there a way I can keep the rest of the fields, not just Employee ID?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703