SOLVED
Looping through dataset
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
prathap2020
5 - Atom
‎12-04-2020
03:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Developer
3 REPLIES 3
Alteryx
‎12-04-2020
03:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎12-04-2020
03:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@prathap2020
Something like this?
‎12-05-2020
07:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
christine_assaad It's working🙂. Thank you so much for your resolution.
