Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to perform with qlikview join the next SQL join statement?
tnx
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
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
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