Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You can try using Not exists() function.
Something like this might be of help:
Temp:
Load * from table2.qvd (qvd);
Table1:
noconcatenate
Load * from table1.qvd(qvd) where not exists(Column1);
Drop table Temp;
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
Load Column1, Col2 From ....
Load Column1, Column2 from.... where not exists(Column1);
Yes, not exists working..Thank you all..:)