Skip to Content
0
May 25, 2018 at 10:28 AM

SAP WebI Ignore records of a data sources if they don't exist in the second data source

196 Views

Hi Guys,

I created a table where it has the following columns "Market"-"Country"-"Status"-"Sales"

The first data source (A) (Bex Query) gives me "Market"-"Country"-"Sales".

The other data source (B) (Bex Query) give me the "Market"-"Country"-"Status".

I merged the similar dimensions and created a key variable.

The result was find, but, is it possible to ignore the records that are coming from the query B and don't exist in A.

Thank you in advance,

Majd