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
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
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.