Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

xtrimf
New Contributor III

SQl Left join on null

Hi,

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

join.png

tnx

Tags (4)
4 Replies

Re: SQl Left join on null

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

Re: SQl Left join on null

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
New Contributor III

Re: SQl Left join on null

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
New Contributor III

Re: SQl Left join on null

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

I'm working with QVDs

Community Browser