Obtain a list from an object on a different table

[Former Member]

Hi:

I'm working on a report that is using two different queries. I want to compare the names from one table (let's say table A) to the list of names on another table (let's say table B).

I tried using a variable something like =[a].[name] in list([b].[name]) but is not working. I researched why and found out that I need to merge the tables. I did but I see that the merge produced an inner join rather than full join. If I have an inner join then, it does not make sense to compare. I need either a full, left or right join to know where a <>b and b<> a. I really want to know how can I obtain a list out of an object. so I can compare both tables.

I'm using the desktop rich client (without patches).

Thanks

[amitrathi239]

check attached blog.

https://blogs.sap.com/2014/12/08/using-merged-dimensions-to-perform-set-operations-union-intersectio...