Connect 2 tables in SAP BO

[slvedva]

I have 2 tables, one table I upload with sql from BW and other from excel.

TableA:

TableB:

When I load the data, I merge field "Article" from both tables. But I don't understand, how to correct make this connection, because the TableA is primary table and I need compare, does articles from the first table exist in TableB and if exist, it should return value "X", if no, then empty field. The output table should look like this:

[krisa24 · Accepted solution]

Hi,

you have correctly merged [Article] objects from both dataset.

Now you should create new variable

Exist? = [Mark]

And set

Qualification: Detail

Associated dimension: merged Article (you will see it in listing under Merged Dimensions)

[slvedva · Accepted solution]

Thanks for help!!!