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;