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!
