Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
xtrimf
Creator
Creator

SQl Left join on null

Hi,

How to perform with qlikview join the next SQL join statement?

join.png

tnx

4 Replies
MayilVahanan

HI

You can use this query itself in qlikview. Before tat, Connect ur db to qlikview via ODBC or oledb connection, then use it..

TableName:

Load *;

Select <select_lisr>  from tableA A left join tableB B on A.key = B.Key    where B.Key is null;

Then store it in the qvd for better performance.

Next time , instead of fetch data from db, use qvd file for better performance

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

You can do like this

Table1:

Load Key,field1,field2 frok Table1 source;

Left Join(Table1)

Table2:

Load Key, Key As Key#,field3,field4 From Table2 Source;

Table3:

Load

     Key,

     field1,

     field2

Resident

Table1

Where Key# IS NULL;

Hope it helps

xtrimf
Creator
Creator
Author

I did it this way ofcourse - but when doing it on millions of records it is not as friendly as the SQL query...

and I also need the right join to get the null value from there also...

Its not pretty

xtrimf
Creator
Creator
Author

I would do that If I had connection to SQL...

I'm working with QVDs