Looping through dataset

[prathap2020]

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
Address	Match Found?
7th Street, DE	No
P.O. Box 283 Fuse Rd.	No
722 Dictum Av. US	YES
P.O. Box 887 2508 Dolor. Av. US	YES
5037 Diam street SA	YES

Table 2

Country

US

SA

DA

IN

PL, DE

[christine_assaad · Accepted solution]

Hi @prathap2020 

Is this what you are looking for? Cheers!

[Qiu]

@prathap2020 
Something like this?

[prathap2020]

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