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
15 - Aurora

@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
15 - Aurora

@sgibson34 find the updated workflow 
mark done if solved.

Labels