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

    Limiting data in a LOAD-statement

      Hello!

       

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

       

      I.e.:

       

      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.