Delete duplicate records based on value from two different columns

[robertfishel]

Hello all.  This is my first post.

I have four columns of data in an Excel workbook.  In columns A and B, there are duplicate values.  Using a VBA macro, columns A and B would be conditionally formatted pink, then filtered and deleted.  In the example below, there should only be two records remaining (as pictured).  How can I accomplish this same task in Alteryx.  Thanks :)

Before

  After

[mborriero]

Hi @robertfishel,

first, I would find the duplicates for the first column and removing them from the original file using a left (or right) join.

Then I would use the same approach tu remove the duplicates in the second column.

Find my solution attached, hoping it helps.

[robertfishel]

Thank you mborriero.  My solution involved summarizing (group by and count of ID), filtering for count of ID  = 1, then joining back to the original table.  I did this again for the ID2 column.