7 Replies Latest reply: May 25, 2016 9:56 PM by Louis Lam RSS

    Qlik Sense Data Load Syntax

    Louis Lam

      Hi All,

       

           Can someone provide a help on converting the query below so that it can be used in Qlik Sense Data Load Editor??

       

      select CustomerID, CompanyName
      from customers as a
      where exists
      (
        
      select * from orders as b
        
      where a.CustomerID = b.CustomerID
        
      and ShipCountry = 'UK'
      );

       

      Best Regards,

      Louis