5 Replies Latest reply: Jun 29, 2011 4:22 AM by Tom Cotterill RSS

    Mimic SQL's IN clause for resident table load.

    Tom Cotterill

      Hello,

       

      Is it possible to mimic a sub query in an SQL IN clause when loading from a qvd? I have a master list in a qvd file but only want to load data that is already present in my resident tables.

       

      For instance I have Tab1 and Tab2 both with the field ‘GP’ for instance:

           Tab1.sGP

           Tab2.pGP

       

      I have a master list of GPs in a qvd file but I only want to load GPs that are in both Tab1 and Tab2.

       

      Please note that Tab1 and Tab2 are resident tables.

       

      I am looking for the equivalent of:

       

      masterPrac:
      NoConcatenate
      LOAD GP AS bridgeGP 
      From D:\Qlikview\QV Data\tbl_GP.qvd (qvd)
      Where GP IN(SELECT sGP Resident Tab1) 
      AND   GP IN(Select pGP Resident Tab2);
      

       

      Many thanks!