How To......

[#1]

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!

[#2]

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;