Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working on capturing a count of rows in a table on a daily basis but want to store that moment in time count in a QVD with the timestamp of when that count was done. But I've been unsuccessful with storing the timestamp (I have been using ReLoadTime) as an historical/QVD table value.
Does anyone have any guidance?
Thank you!
Hi,
You can try something like this to include the timestamp when storing the data in QVD.
ABC:
Load Field1,Field2, now() as TimeStamp from xyz;
Store ABC into ABC.qvd;
Regards,
Kaushik Solanki