Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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];

Tags (4)
Community Browser