Free Trial

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
Top Solution Authors