Hello Friends,
Need your help on below:
There are two different queries and tabs (One tab for each query) in Webi Report BI 4.2
Query 1 - Account Number1 column has 100 records
Query 2 - Account Number2 column has 2000 records
On the report, I need to compare the data between Account Number1 and Account Number2 and need to flag them as Y or N in a different column. Need to show this Flag in Query 1 where the tab has only 100 records.
If Account Number1 = Account Number2 then Y Else N
If statement is not working in this scenario as these two columns are coming from two different universes/source and merge dimension is not useful.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.