Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Cross check data from different sources

Highlighted
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!

Quasar
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

Highlighted
Atom

Hi ydmuley

 

thank you so much, it works great :)

Highlighted
Quasar
Quasar

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

Labels