Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use data qvd to import another table with odbc

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

0 Replies