Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Cross check data from different sources

ulke_86
5 - Atom

Hello community,

 

I have two data sets. One contains products that have been ordered by customers within a defined time period. Each product has a unique product ID.

 

The second data set contains a list of product IDs for certain products that we flag as having a high potential.

 

Now I would like to have a new column in data set one that has an "X" in it if the ordered product can be found in data set 2 sa a product of high potential. So I need to check for each product ID in data set 1 whether it is a product ID that is listed in data set 2.

 

Thank you for your help!

3 REPLIES 3
ydmuley
12 - Quasar
12 - Quasar

Hello @ulke_86 - Try using 'Find Replace Tool' which will give you values that are available in the second data set.

 

This way you will be able to filter the nonnull dataset and tag them as X.

 

Thanks,

Yug

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
ulke_86
5 - Atom

Hi ydmuley

 

thank you so much, it works great :)

ydmuley
12 - Quasar
12 - Quasar

@ulke_86 I am glad that it helped you! All the Best!

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
Labels