3 Replies Latest reply: Dec 15, 2014 10:47 AM by Chris Iannicello RSS

    Exclude partial month data from Script Load?

      I have data I'm importing from a QVD file that has multiple rows of data for each day, for example:

       

      LOAD

      Date,

      Month,

      Year,

      Amount

          

      FROM

      data.qvd

      (qvd);

       

      This data has activity every day, so every date has data in it.

       

      I'm trying to put in a WHERE clause to exclude the most recent month's worth of data but only if it's a partial month.  That way I can load the data from my QVD with only full months' worth of data.

       

      I was trying to use MonthEnd function, but cannot seem to get it right.

       

      Thanks all.