8 Replies Latest reply: Dec 26, 2017 4:39 AM by Hari Prasath RSS

    Where Condition from another QVD

    Janani Reddy
    Janani Reddy Dec 26, 2017 4:09 AM

      Hi Guys,

       

      My current script in the data load editor looks like this

       

      LOAD * FROM [lib://QVD/Loans.QVD] (qvd) ;

      .

      .

      .

      .

      LOAD * FROM [lib://QVD/Product.QVD] (qvd) ;

       

      What i want to do is add a where condition in my products data to load only the products present in Loans .. These two are linked by "Product" column and this logic can be achieved like this


      Load * from Product

      where Product in (Select Product from Loans)



      How can i do this in my QVD script?