Hi,
If i well understodd what you want to do, yes I think its possible. To verify if the value changes overtime, you need to write the timestamp when you check it.
A solution could be to store historical values in a QVD.
Example of script :
The first time you create the QVD :
TABLENAME:
SELECT your chain connection...
YourField, now() as Date
...;
store TABLENAME into QVDNAME.qvd;
When created, clear your script and then use something like this :
TABLENAME:
load * from QVDNAME.qvd;
concatenate
SELECT your chain connection...
YourField, now() as Date
...;
store TABLENAME into QVDNAME.qvd;
This script will load you past data and meet them with the last reload values and store all in a new qvd. Each time you will reload, the QVD add a line to your data.
Hope this meet your needs.
