0 Replies Latest reply: Nov 15, 2012 10:36 AM by Koen Matten RSS

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