Conditional Duplicates

rrafferty2

I need to remove (or flag) duplicates that meet certain criteria.

For example, I split my data set into 2 groups, group 0 and group 1

How do I remove (or flag) the duplicates in group 1 which are dups of group 0

Thanks

Robb

AbhilashR

Hi @rrafferty2, does the attached solution get you what you are looking for? Give it a try on your larger dataset and let us know if it addresses your ask. I have included some comments in the workflow itself to give an overview of the operations.

Source Data:

De-Duped Dataset:

Let us know if this doesn't work.

sample.yxmd