We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Removing Mirrored Duplicates

sgibson34
5 - Atom

My data has quite a few instances where the rows are duplicate, but the values are just mirrored in different columns. I want to remove the duplicate instance and keep the original. For example, if row1 = x   y    and row2 =   y    x     I want to get rid of the second row but keep the first. 

3 REPLIES 3
Raj
16 - Nebula

@sgibson34 
find the workflow attached
mark done if solved.

sgibson34
5 - Atom

I could use this if i could concatenate the data from the two columns together, how would i do that? 

Raj
16 - Nebula

@sgibson34 find the updated workflow 
mark done if solved.

Labels
Top Solution Authors