topic Incremental Load, data chuncked by month in QlikView

Incremental Load, data chuncked by month

Wed, 25 Jan 2012 01:59:12 GMT

Hi,

I would like know how to perform an incremental load where in it will produce a qvd for the current month and the succeeding month?

Lets say this month, I perform an incremental load, only the data for this month will be stored in the January.qvd and if current month = February, data for feb are only sotred in the qvd.

Another question, How is the maintainability for this kind of setup?

Many Thanks!

Incremental Load, data chuncked by month

Wed, 25 Jan 2012 07:49:07 GMT

Incremental Load, data chuncked by month

Wed, 25 Jan 2012 09:09:53 GMT

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(monthstart(today()))# ;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT Exists(PrimaryKey);

STORE QV_Table INTO File.QVD;

by implementing the above code it will load only the data from the start of the current month till the max date.

Incremental Load, data chuncked by month

Wed, 25 Jan 2012 09:33:44 GMT

I have a dynamic qvd filename that will change when the current month changes, for example current month = January2012 and then tomorrow current month = February2012.

How can I assure that the data inside January2012.qvd are only for january and are complete and what if the new data are entered on February but there are new data for January.