topic Incremental updates in QlikView

Incremental updates

Thu, 25 Feb 2010 10:33:06 GMT

Hi All,

First post!

I'm trying to create a qvw that takes a daily incremental file and adds it to the data loaded on all previous days. I see you can load a set of spreadsheets from a folder but cannot work out a solution to add the file which is named the same every day to the data loaded previously.

An example is I get a file of sales order every day called salesorders.csv which overwrites the previous file. I need to load the data every day with the existing data loaded from previous days so that historical analysis can take place.

Any help is very much appreciated.

Regards

Sijeffs

Incremental updates

Thu, 25 Feb 2010 10:47:13 GMT

Hi, You can store your historical data in a QVD.

Every day, you load the new data and the last day QVD in your application then update the QVD for the next day.

Incremental updates

Thu, 25 Feb 2010 10:55:41 GMT

Using something like this piece of script:

Table:
SQL SELECT * FROM DB_TABLE;

Concatenate
LOAD * FROM File.QVD;

STORE Table INTO File.QVD;