2 Replies Latest reply: Oct 1, 2014 12:17 PM by Jay Mathers RSS

    Help with QVD load

      I'm trying to extract out of SAP. I have two date fields in my table. One is 'Snapshot week' and the other is 'Calendar Week'

       

      For one Snapshot week, I have historical forecasts (-1, -2, -3 and so on) and then I have future forecasts where (1,2,3,4 and so on)

       

      So if my snapshot week was 9/1/2014, the historical forecast would include 8/25, 8/18, 8/11, 8/4 and so on

      and the future forecast would have 9/1/, 9/15, 9/22, 9/29 and so on.

       

      I want to limit the load so that it only brings in current snapshot week and 10 weeks of historical forecast data. This is what I have so far but it doesn't bring in any historical forecast data....so any idea on how to bring in the historical 12 weeks of forecast data?

       

      SQL Select *  from SAP_Table

      Where /[Snapshot Week] = 201439;

      STORE * FROM SAP_TABLE INTO $(vRootPath)\Data\QVDs\Forecast.QVD;