Discussion Board for collaboration on QlikView Scripting.
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
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
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