Alteryx Designer Desktop Discussions

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

Looping through dataset

prathap2020
5 - Atom

Hi,

 

I am trying to iterate each value in the "Address" column from my table 1 to the "Country" column in the table 2 and create a new column in the table 1 as "Match Found - YES/NO"

 

Table 1 
AddressMatch Found?
7th Street, DENo
P.O. Box 283 Fuse Rd.No
722 Dictum Av. USYES
P.O. Box 887 2508 Dolor. Av. USYES
5037 Diam street SAYES

 

Table 2
Country
US
SA
DA
IN
PL, DE
3 REPLIES 3

Hi @prathap2020 

 

Is this what you are looking for? Cheers!

 

christine_assaad_0-1607125527119.png

 

Qiu
20 - Arcturus
20 - Arcturus

@prathap2020 
Something like this?

1205-prathap2020.PNG

prathap2020
5 - Atom

 It's working🙂. Thank you so much for your resolution.

Labels