2 Replies Latest reply: Jul 6, 2011 11:15 AM by Dave Riley RSS

    Restricting QVD Load by dimensions already loaded

      Hi all,

       

      Currently we have an Application selecting Data from QVD files (one per Table).

      Please look at the following:

       

      Orders:
      LOAD * FROM orders.qvd (qvd);

       

      Positions:
      LOAD * FROM positions.qvd (qvd);

       

      Currently this also selects positions that have no correlating orders, what I'd like to do is restrict the positions load to only those with an order_id located in the id-column of the Orders table.

       

      The first thing coming to my mind is concatenating all entries in the Orders.Id Column to a large string and in the next step filtering by this string using where order_id in. But then again, there should be a more native way of doing this in QV, shouldn't there?

       

      Any hints highly appreciated!

       

      Thanks