topic Re: SQl Left join on null in QlikView

SQl Left join on null

xtrimf — Thu, 14 Mar 2013 14:28:35 GMT

Hi,

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

tnx

MayilVahanan — Thu, 14 Mar 2013 14:33:49 GMT

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

CELAMBARASAN — Thu, 14 Mar 2013 14:33:57 GMT

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 — Thu, 14 Mar 2013 16:18:16 GMT

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 — Thu, 14 Mar 2013 16:18:53 GMT

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

I'm working with QVDs