Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am aware of incremental load on daily basis but how to implement if data load frequency is on monthly based.
Hi,
You want to schedule it on monthly basis, with the incremental logic you have.
Regards
post a sample script of yours
Use a condition something like this in to call sub which loads the data
if (max(monthname) > Monthname(Monthname(today())-1), callSub())
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;
Hi,
Instead of modified date, try with month (use the monthname function will give month and year )