Skip to Content
0
Jun 03, 2020 at 08:16 PM

SAP Webi vlookup function problem

108 Views Last edit Jun 02, 2020 at 11:14 PM 3 rev

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