In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
21 - Polaris
21 - Polaris

@prathap2020 
Something like this?

1205-prathap2020.PNG

prathap2020
5 - Atom

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

Labels
Top Solution Authors