I've had a very quick look. Do you have somewhere that you can keep qvd files? My preference would be to use a qvd and then do the following:
Let vtime = Date(ReloadTime(),'DD/MM/YYYY');
Let vtoday = Date(now(),'DD/MM/YYYY');
LET vFilePath = 'C:\Test';
// If the dates are equal, load the existing qvd back into the table
if $(vtime) = $(vtoday) then
Load * from $(vFilePath)\TEST.qvd(qvd);
// If dates are not equal, Load whatever you need here
If $(vtime) <> $(vtoday) then
* Inline [
//Store new data into the qvd
Store TEST into $(vFilePath)\TEST.qvd(qvd);
I'm not sure if there's a way of retaining data in an actual table in a script - hence the use of a reload from a QVD. This could have an impact on storage space etc though if your datasets are large. It could also take longer to run the script.
Hopefully, someone will post on here with some code that will allow the table to retain the data that was already in it - that would be really useful. In the meantime, the above solution will work, but is more clumsy.