4 Replies Latest reply: Jan 8, 2013 8:59 AM by Michael Ionkin RSS

    Incremental load (update 7 past month)

    Michael Ionkin

      Hello

       

      I want to do an incremental load. From the basis qvd I want to take everything earlier then 7 month (7*30 days) and then find out the highest ID.

       

      is this script correct?

       

       

      LOAD

       

      lMacStaRef,
      Beginn

      FROM
      ..\..\02_Data\Result1.qvd
      (
      qvd) where (Interval(Now() - Beginn) >= 210);

      Let UpdateID = Max (lMacStaRef);

      Thx in advance