Hi,
I have two lists of customers ID, A and B. A and B are from different data base. Hence I use two queries. A's data base is the whole SAP revenue report. B is just an excel document, with a column of customer ID. I intend to divide my A list into two categories: Special customers and other customers. If A customer ID is in B list customer ID, then they are special customers. If not, then they are normal customers. As a result, I hope to get two columns, the first column is the A list customer ID, the second column is the category.
I first merged customer ID list A and B into a merged dimension.
Then I created a variable (dimension detail): IF([customer ID A]=[customer ID B]) Then"S" Else "O"
, but it does not work...
In SAP does it automatically compare two columns row by row? How to check each cell in A with the entire list in B?
Thank you in advance.
Best,
Grace