I'm trying to find a way to capture the previous days data before the the new data is loaded, so I end up with something similar to the below:
Data on 27/02/2022
Data on 28/02/2022
1
3
2
5
3
7
4
3
My thoughts were that i would first have to store the data at the beginning of my script into a QVD (e.g. HistoricalData.qvd) then at the end of my script I would have to load that HistoricalData.qvd back in for comparison? But i can't quite get it to work.
Does anyone have any suggestions or example scripts that I could refer to ?
