Hi All,
I have following fields in my Bex query .
Query1 :CustomerID,Signed Date, Create Date, End date , End Reason.
Query2: CustomerID,Signed Date, Create Date, End date
I want to create a report to display Query1 data and add a flag to show whether customerIDs match in two queries or not.
I have created a merged dimension on CustomerID and created condition as Var1= ( IF(Query1.customerID=Query2.CustomerID ;Match;NoMatch)).
The moment I add Var1 to the report, it is displaying only match records and filtering out all Nomatch records but, I want to show entire data set with flag Column displaying match and no match .
We don't want to create universes over Bex queries and do this.
Any help or suggestions are really appreciated.
Thanks,
Raja