I have been struggling for quite a while and scanned the forums to come up with a method how to load the latest information from my qvd files which are created everything morning around 5 am from a database pull. This original qvd file I would not like to ammend as it is used by many applications.
I have another application where I would like to load the latest records e.g. max(date(Transact_time, 'DD/MM/YYYY')) or from the previous day. max(date(Transact_time, 'DD/MM/YYYY')-1). (my dates are all dates + times stamps)
TEMP:
LOAD
max(Date) AS MAX_Date
FROM
[file1.qvd]
let vTemp=MAX_Date
drop table TEMP;
Table1:
LOAD
Field 1
Field 2
Date
FROM
[file1.qvd]
WHERE Date >= $(vTEMP);
The above is an example of a method I have tried with no success as well as trying to Join/resident tables. The outcome I would like is if i have 1 years worth of data in a QVD, I am only targeting 1 day, however could have 1000 different timestamps which are all included in the load.
