Skip to Content
0
Nov 24 at 02:49 PM

Connect 2 tables in SAP BO

91 Views

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

TableA:

image.png

TableB:

image.png

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:

image.png

Attachments

image.png (4.9 kB)
image.png (2.5 kB)
image.png (7.4 kB)