Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Matching 2 columns

TonyMu
8 - Asteroid

Hello, 

 

I would like to find and report the records where a value Column 3 repeats in column 5. se below: 

 

Column1Column2Column3Column4Column5
143154315431422
2458964521543
378683568354443
4966824453488
52612322123229008
6833488454411

 

output:

Column1Column2Column3Column4Column5
143154315431422
2458964521543
4966824453488
6833488454411

 

Is there anyway to do this? 

Cheers,

Tony

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @TonyMu,

 

I have prepared a workflow for you:

 

Emil_Kos_0-1611520694510.png

Please mark my solution if this was helpful!

AngelosPachis
16 - Nebula

Hi @TonyMu ,

 

A quite unorthodox way but it turned out it works.

 

AngelosPachis_0-1611521157231.png

 

 

I have also tested it slightly by adding different values to Columns 3 and 5 and seemed to be doing alright, the results looked correct.

 

Let me know if that works for you.

 

Cheers,

 

Angelos

Labels