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:


      LOAD * FROM orders.qvd (qvd);


      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!