Discussion Board for collaboration on QlikView Scripting.
I have 2 qvd files and want to select records from a qvd file which are not present in other.
Table 1 :
What i want is records C, D from table A.
Go to Solution.
Try this code,
Table2:LOAD Column1, Col2FROM[http://community.qlik.com/thread/112713](html, codepage is 1252, embedded labels, table is @2);
Table1:LOAD Column1, Column2FROM[http://community.qlik.com/thread/112713](html, codepage is 1252, embedded labels, table is @1)Where not Exists (Column1,Column1);
DROP Table Table2;
and please refer attached file, it will help you.
You can try using Not exists() function.
Something like this might be of help:
Load * from table2.qvd (qvd);
Load * from table1.qvd(qvd) where not exists(Column1);
Drop table Temp;
Load Column1, Col2 From ....
Load Column1, Column2 from.... where not exists(Column1);
Yes, not exists working..Thank you all..