Incremental loads

[#1]

Hi

I create an incremental script , i am trying to load only the row that add to table source by Date.

when  there is no new rows add to table source i get somthing strange:

on the first reload i get an empty table , when i reload again i get the all data

why?

Failures:

  LOAD Serial_Number,

     Name,

     Date,

     event_recnum,

     Engine_Number,

     SW_Version,

     EndTime,

     Imps_Counter,

     Restarts_During_Recovery,

     WeekendTimeDuringFailure,

     DownTimeDuringFailureWeekend,

     DownTimeDuringFailureRegular,

     NightTimeDuringFailure,

     NightModeTimeDuringFailure,

     SpecialCustomerJobs_Imps,

     SpecialJobs_Imps,

     [RecoveryTime(seconds)],

     NullsDuringFailure

FROM

Data\iserve_Data.xlsx

(ooxml, embedded labels, table is SHARONֹFAILURES)

where Date >= '$(V_max_date)';

Concatenate

load * from Failures.qvd;

store Failures into $(path_xls)Failures.qvd;