Store each day data into a QVD file. This storage can be incremental (only one QVD file with more records each day) or multiple files, one for each day, so you can chose later on which of the QVD files will load.
LET vFileDate = Date(Today(), 'YYYYMMDD'); DailyData: LOAD * FROM Excel.xls (biff, explicit labels, table is Sheet1$); STORE DailyData INTO $(vFileDate).qvd (qvd); DROP TABLE DailyData; AllData: LOAD Date, Meat, Number FROM *.qvd (qvd);
The first line creates a variable with no special characters to be used as the name of the file. The result will be files named like 20111104.qvd, 20111205.qvd and so on.
The DailyData table loads only data from today, irrespective the changes, and stores into a file like above.
The AllData table loops in the specified folder and loads all QVD files, so you have data from all days. Since all files have the same number and name of fields, all records are concatenated automatically which is very convenient in this case.
Now you can modify the code to fir your needs, load only when not exists, and so. If needed, you can easily create a loop to load only the last month, last year or any given period with i.e.: a For Next loop.
Hope that gives you an idea.
This is brand new to me , I have tested with a sample file , this is my script
LET vFileDate = Date(Today(), 'YYYYMMDD');
FROM [S:\Business Support\Qlikview\Tester\Incremental loads\Data.xls]
(biff, embedded labels, table is Sheet1$);
STORE Data INTO $(vFileDate).qvd (qvd);
DROP TABLE DailyData;
FROM *.qvd (qvd);
And these are the errors -- Could you advise if I have done something incorrect ?