How to create/append a new QVD based on the refresh date of the existing QVD?

[Anonymous]

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.

[prieper]

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 ....