Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Matching 2 columns

TonyMu
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 ANTWORTEN 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
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

Beschriftungen