Use data qvd to import another table with odbc

Thu, 15 Nov 2012 15:36:43 GMT

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];

topic Use data qvd to import another table with odbc in QlikView