Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Remove Every Iteration of a Duplicate

jenner85
8 - Asteroid

Hi - 

 

I would like to remove all instances of a duplication in my data, not just leaving behind one of the rows. For example, I would like this data to only return the rows for Mike and Amy and remove both Jen lines. 

 

NameArea
Jen

Ottawa

JenToronto
MikeOttawa
AmyVancouver

 

Thanks!

 

Jen 

1 REPLY 1
danrh
13 - Pulsar
I actually designed a macro to do just this a while back! Works just like the Unique tool, but outputting ALL the duplicates to the "D" stream. See attached.
Labels