topic Re: Incremental load-monthly in QlikView

Incremental load-monthly

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Mon, 25 Jul 2016 01:16:05 GMT

Hi,

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

Regards

Mon, 25 Jul 2016 02:59:42 GMT

post a sample script of yours

gouthamkk — Mon, 25 Jul 2016 04:03:45 GMT

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

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

Mon, 25 Jul 2016 05:08:14 GMT

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 — Mon, 25 Jul 2016 05:13:17 GMT

Hi,

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