Selecting records from a table which are not present in other

[#1]

Hi,

I have 2 qvd files and want to select records from a qvd file which are not present in other.

Lets say:

Table 1 :

Column1	Column2
A	12
B	14
C	15
D	20
E	45

Table 2:

Column1	Col2
A	7
B	8
E	9

What i want is records C, D from table A.

Thanks

[#2]

You can try using Not exists() function.

Something like this might be of help:

http://community.qlik.com/message/492029

[Gysbert_Wassenaar]

Temp:

Load * from table2.qvd (qvd);

Table1:

noconcatenate

Load * from table1.qvd(qvd) where not exists(Column1);

Drop table Temp;

[VishalWaghole · Accepted solution]

Hi Pallavi,

Try this code,

Table2:
LOAD Column1,
     Col2
FROM
[http://community.qlik.com/thread/112713]
(html, codepage is 1252, embedded labels, table is @2);

Table1:
LOAD Column1,
     Column2
FROM
[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.

- Regards,

Vishal Waghole

[MK_QSL]

Load Column1, Col2 From ....

Load Column1, Column2 from.... where not exists(Column1);

[#6]

Yes, not exists working..Thank you all..:)