topic How To...... in QlikView

How To......

Wed, 06 Apr 2011 01:17:04 GMT

Hi All,

Is this possible in Qlikview's Load Script

WHERE Customer_Number IN

(SELECT yy.Customer_ID FROM surfacefee_staging_table WHERE Trucker='EXPLORER')

by the way i'm loading excel files...

thanks!

Wed, 06 Apr 2011 01:50:48 GMT

in qlikview you must pre load your sub-query into a table, then use the where EXISTS. The you can drop your subquery table.

Something like...>

tempExplorer:
LOAD Customer_ID;
SELECT Customer_ID from surfacefee_staging_table where Trucker='Explorer';

LOAD * from Excel WHERE EXISTS(Customer_ID,Customer_ID);

DROP TABLE tempExplorer;