Incremental load-monthly

[#1]

Hi,

I am aware of incremental load on daily basis but how to implement if data load frequency is on monthly based.

[#2]

Hi,

You want to schedule it on monthly basis, with the incremental logic you have.

Regards

[#3]

post a sample script of yours

[gouthamkk]

Use a condition something like this in to call sub which loads the data

if (max(monthname) > Monthname(Monthname(today())-1), callSub())

[#5]

Please find below sample script

Incremental:

LOAD
Region,
ID,
Product,
Sales,
Modified_Date
FROM
Sales.xlsx (ooxml,embedded labels,table is Sheet1) where Modified_Date>$(Last_Updated_Date);

//Concatenate with QVD
Concatenate
LOAD Region,
ID,
Product,
Sales,
Modified_Date
FROM Sales.qvd(qvd) where not Exists(ID);

//Replace Old QVD file
Store Incremental into Sales.qvd(qvd);

//Drop Incremental Table

Drop table Incremental;

[settu_periasamy]

Hi,

Instead of modified date, try with month (use the monthname function will give month and year )