Incremental updates

[#1]

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

[#2]

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.

BR

[#3]

Using something like this piece of script:

Table:
SQL SELECT * FROM DB_TABLE;

Concatenate
LOAD * FROM File.QVD;

STORE Table INTO File.QVD;