topic using where exists() on sql load in QlikView

using where exists() on sql load

Wed, 15 Apr 2015 17:03:42 GMT

Hi,

i have a small problem with "where exists" and a sql load and did not find existing solutions while searching the community. Where existst works fine with qvd containers or resident loads, but seems not to work with external sql sources.

my goal is to limit a load from a qvd container and then limit the load form a sql database by a field from the previous qvd load.

customers:

LOAD

CU_ID,

firstname,

lastname,

company,

areacode,

createdate

FROM

$(vQVDstore)customers.qvd

(qvd)

where createdate>=20100101

;

ORDERS:

SQL SELECT * FROM DB."customer_orders"

where exists (CU_ID)

;

All i gt is an error. where exist works with other loads and SQL supports where exists like in this example:

SELECT *

FROM suppliers

WHERE EXISTS (SELECT *

FROM orders

WHERE suppliers.supplier_id = orders.supplier_id);

I will appreciate any help or suggestions, thank you

Re: using where exists() on sql load

maxgro — Wed, 15 Apr 2015 18:20:55 GMT

where exists (select * from ......) is a valid sql syntax (subquery)

where exists (CU_ID) isn't a valid sql syntax

you are making a mix between sql syntax and qlikview syntax trying to ask to the database server to check for a valid CU_ID (field of a QlikView in memory db)

I think it could be

ORDERS:

load * where where exists (CU_ID);

SQL SELECT * FROM DB."customer_orders";

the SQL ....... read all the table from the dbms

the load filter CU_ID in QlikView

Re: using where exists() on sql load

Anonymous — Fri, 17 Apr 2015 00:58:25 GMT

Does anyone have a solution for an incremental load situation, where we would like to avoid loading the entire table and then filtering? Specifically, after a load of a qvd that contains order numbers, only select those rows from the database using the order numbers from the qvd. In this situation there is no other way to identify the records in the database.

Thanks for any ideas.

Re: using where exists() on sql load

maxgro — Fri, 17 Apr 2015 16:05:58 GMT

usually there is a timestamp, date, a field (createdate?) to identify changed record from last qlikview reload

in QlikView help there is a "using qvd file for incremental load" with 4 different examples