Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the source data as follows:
Table1:
column1,
column2,
column3
from dbo.rawdata
stored into rawdata.qvd
wherein I would like to have a new QVD based on the rawdata.qvd as:
Table2:
RefreshDate,
column1,
column2,
column3
from rawdata.qvd
store into Final.qvd
Hence I would like to have Final qvd consisting of historical data based on REFRESH date stored on daily basis.
data:
LOAD
NOW() AS Refreshtime,
Column1, ...
FROM Rawdata.qvd (qvd);
STORE
data INTO Final.qvd (qvd);
Instead of NOW() you may also take RELOADTIME() or the like.
Peter
edit:
For adding new data
LET vFileTime = FILETIME('RawData.qvd');
Data: LOAD * FROM RawData.qvd (qvd);
CONCATENATE LOAD * WHERE RefreshDate >= $(vFileTime);
STORE Data INTO ....