4 Replies Latest reply: Feb 28, 2014 4:28 AM by Sahas Ullur RSS

    Date Variable in Where clause in load script

      Dear All,

       

      I need to put a where clause in load script.

       

      Example :

      LET vCutoffDate = makedate(2013);

       

      LOAD [Invoice Date], [Standard Invoice Qty], [Invoice Amount], [Cost Value], [Invoice #]

      FROM

      Sales.QVD (qvd) WHERE [Invoice Date] >= vCutoffDate ;

       

      How to achieve this ? Your help is badly needed.

       

      Note : I do not want to change the SQL which is used to get data from DB using Select statement.

       

      Regards,

      Sahas