0 Replies Latest reply: Nov 7, 2017 9:51 AM by Rajesh Santhana Krishnan RSS

    Qlik Sense Data Load Syntax Help - 'Where in' Clause + Select Subquery + Logical operator

    Rajesh Santhana Krishnan

      Hi,

       

      I am looking to load the data in Qlik Sense using a where clause from multiple temp tables that are loaded in the same code. Below is sample Psuedo code that looking to implement. Please suggest the right syntax and other better ways to load the data. Thanks a lot in advance for the help!!

       

      Sample Code

       

      Table1:

      LOAD *

      FROM [lib://masterdata.qvd];

       

      Vendor:

      LOAD "Vendor Name"

      FROM [lib://vendordata.xls];

       

      CostCenter:

      LOAD "Cost Center ID"

      FROM [lib://costcenterdata.xls];

       

      /// Need help with the syntax for the below code ////

      Table 2:

      Load * Resident Table 1

      where exists (select [Vendor Name] from Resident Vendor) OR exists (select [Cost Center ID] from Resident CostCenter );

       

      Drop Table Table1,Vendor, CostCenter;

       

      Thanks,

      Rajesh