Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental loads

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;

0 Replies