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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt137
Contributor
Contributor

Storage data with today's datastamp

Hello,

I've got one question I'm working with database that doesn't have any dates relatable to show any progression in data.
I've been meaning to concatenate everything to one table, add one field corresponding to today's date and then storage this into qvd file once a day. 
My question is if it will work and I'll get the data separate with this timestamp and everydays new load will add up to the record number e.g. first load will be 2000 and after second day it will be 4000  (2000 from first day and 2000 from second)?

Data:
Load Distinct
*,
Today() as dateflag
Resident Data_tmp
STORE Data INTO [lib://[..]QVD](QVD);

Labels (1)
1 Reply
Chanty4u
MVP
MVP

May be this

Just add Date(Today()) as DateFlag  in the load script