Discussion Board for collaboration on QlikView Scripting.
How to perform with qlikview join the next SQL join statement?
You can use this query itself in qlikview. Before tat, Connect ur db to qlikview via ODBC or oledb connection, then use it..
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
You can do like this
Load Key,field1,field2 frok Table1 source;
Load Key, Key As Key#,field3,field4 From Table2 Source;
Where Key# IS NULL;
Hope it helps
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
I would do that If I had connection to SQL...
I'm working with QVDs