Get Not matching Data

[Former Member]

Hi Experts, In BODS we have Inner Join  and left Outer Join 1. Inner Join Will fetch matching Data 2.Left Outer Join will fetch All the Data from left table and matching Data from right table My Doubt is how to fetch not matching Data from both Table or from one table Please let me know your Suggestions Thanks

[former_member210439]

Hi Uhdam,

Please follow the steps to get desired result.

Join two tables using  LEFT OUTER JOIN on Table1. Key = Table2.Key and add Table2.key into query mapping.

After join condition add one more query transform and put where condition as Table2.column is NULL.

Now  you would get the list of values from left table which are not in the right table.

Hope this helps.

Thanks,

Deepak

[former_member187605]

Do you mean?

     select * from table1

     where key1 not in (select key2 from table2)

You can achieve this by using the pushdown_sql built-in function in the WHERE tab of the Query transform:

     pushdown_sql('<datastore>','key1 not in (select key2 from table2)')