topic Re: where exists syntax with sql in QlikView

where exists syntax with sql

rdsuperlike — Sat, 15 Aug 2015 00:13:15 GMT

I want to do

Table1:

Load

a_key,

SQL

select * from

......;

where not exists (a_key)

from tab2.qvd;

Load

a_key,

SQL

select * from

......;

MINUS

Tab2.qvd

but looks like syntax is wrong.

Can someone help me here?

Re: where exists syntax with sql

Anonymous — Sat, 15 Aug 2015 01:25:33 GMT

Hi,

Is this complete script?

Re: where exists syntax with sql

sunny_talwar — Sat, 15 Aug 2015 02:41:51 GMT

Table1:

Load

a_key,

b,

c;

SQL

select * from

......;

where not exists (a_key)

from tab2.qvd;

Are you trying to load data from SQL where a_key is null? Is that the intention here???

Re: where exists syntax with sql

marcus_sommer — Sat, 15 Aug 2015 09:37:14 GMT

You couldn't apply a exists() to a sql-statement because it's a qv function. Commonly used in such cases is Preceding Load. Another possibilities are to load the sql-table complete and apply then a second load with an exists() filter - see also: The exists issue - or using a join/keep to filter your table.

If your sql-load is quite large it could be useful to convert the exists-logic in a sql-function like SQL: IN Condition.

- Marcus

Re: where exists syntax with sql

Sun, 16 Aug 2015 16:15:56 GMT

You should load Table2.qvd and after that the LOAD with exists previous to the SQL:

Table2:

LOAD

    a_key,

    *

FROM Table2.qvd(qvd);

SQL_Table:

LOAD

    a_key, b, c

where exists(a_key, a_key);

SQL SELECT * FROM Table;