Alteryx Designer Desktop Discussions

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

how to check similar records base on two columns

Krit_Gable
8 - Asteroid

Suppose I have two  Columns I want to check similiar records like this

 

 

Destination1Destination2
AB
AD
BA
BC
CA
CB

 

I would like to check similiar record from Destination1 <-> Destination2 like A->B and B->A is similiar I would like to filter it out

so the result would be like

 

Destination1Destination2
AB
AD
BC
CA

 

Is there any idea to clean the duplicated data out?

Thanks in advance

2 REPLIES 2
Inactive User
Not applicable

Answer attached.

Krit_Gable
8 - Asteroid

Thank you for idea

Labels