This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.