Hello,
I have a qvd with al the companies we need to visual in qlikview.
I need to read the records of the companies to get the right custumers out of the ODBC-database.
Now i read first all the records of all the companies and after that i do a test
"where exists(firnr)". Result is 200 000 reads in the ODBC database while i only need 15 000 customers...
can someone help me?
NOW I HAVE :
[Cust]:
LOAD comp & '-' & custnr as %Key_Customer,
name as Name_Customer
where exists(comp);
SQL SELECT comp,
custnr,
name
FROM PUB.cust;
STORE [Cust] INTO customer.qvd;
DROP TABLE [Cust];
MUST SOMETHING LIKE THIS :
[Cust]:
FOR EACH COMP :
LOAD comp & '-' & custnr as %Key_Customer,
name as Name_Customer;
SQL SELECT comp,
custnr,
name
FROM PUB.cust where cust.comp = comp.comp ;
END.
STORE [Cust] INTO customer.qvd;
DROP TABLE [Cust];
