Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to achieve a subquery with qvd's

can anyone explain how to achieve the following using qvd.

select ID, Name from Table1

where ID not in (Select ID from Table2).

i will like a qvd version.

thats is i want only the IDs from table1 where not Exist int Table2

2 Replies
Not applicable

Re: how to achieve a subquery with qvd's

Where clause work on same table from where u loading..

its not u are loading from one table ,bt condition u r applying for other table

regards-bika

mov
Esteemed Contributor III

Re: how to achieve a subquery with qvd's

You have to load table 2 first, and use "not exists" when loading table 1.  See the very recent http://community.qlik.com/message/369556#369556

Regards,

Michael

Community Browser