Hi,
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 ?
Thanks,
