Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current Timestamp as historical Timestamp?

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!

Labels (1)
1 Reply
kaushiknsolanki
MVP
MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!