In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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