Cross check data from different sources

[ulke_86]

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!

[ydmuley · Accepted solution]

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

[ulke_86]

Hi ydmuley

thank you so much, it works great :)

[ydmuley]

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