Incremental loads

Thu, 20 Sep 2012 07:56:26 GMT

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;

topic Incremental loads in QlikView