Store and reload table

[StefanW]

At the moment I load Data with an MDX querry from an Excel Cube to generate a linegraph. After loading the data I generate a usable table which looks like this:

Date: 27.05.2022

Cashflow: 50000.00

timeband: 0Y <= 2Y

The Problem is that not all data is stored in the Cube and only recent data is in there. As soon as 5 dates are stored the oldest one is deleted due to ressource management. 

What I want to do is load the table and append the newest addition of data to a csv that is stored locally and loaded if I want to compare the neweset data to older dates. 

Now the question is, can I define in the load script to append the new data to an existing csv or Excel file or can I as a solution store the most recent date in a new file with the date in the filename and load all those files to compare the dates. 

Thank you for the help in advance.

kind regards Stefan

[Ruhulessin · Accepted solution]

Hi @StefanW,

I would load the file as is and store it as a QVD file.
Next time load in that QVD file and concatenate the data from the Excel Cube where date is larger then the max date in the QVD.
Then store/replace that QVD with the added records to built up your history in that QVD.

-Ruben