Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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