12 Replies Latest reply: May 28, 2013 7:22 AM by Marcus Jirak RSS

    Limiting data in a LOAD-statement



      When I select data from an ODBC-source, I can limit the selected data with the WHERE-clause.




      SELECT *


      from BI.example

      where DATE > '01.01.2006';


      I'd like to know the equivalent, if I LOAD data from a .qvd-file and only want to load data which match the given criteria, i.e. only one specific customer-ID. The WHERE-clause doesn't work in combination with LOAD, afaik.


      I bet this is a simple thing but I didn't figure it out yet.