Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
May be this
Just add Date(Today()) as DateFlag in the load script