Can not Get Incremental Load to work

[iswarya]

Incremental load the PriceList with New_PriceList Data

[JordyWegman]

Hi Iswaryak,

You can do the following script daily:

let vToday = floor(today);

TableIncrement:
Load
   Date,
   Price,
   Item_code
From [YourSource](qvd)
Where Date = Date($(vToday),'MM-DD-YYYY')
;

let vDate = Date($(vToday),'MM-DD-YYYY');

STORE TableIncrement in [YourFolder]TableIncrement_$(vDate)_M.qvd (qvd);

Jordy

Climber