3 years of data

[Prabhu1204]

Hello All,

I have a qvd with incremental logic. That qvd should always have only 3 years of data. Could you please help me on the logic.

I used the below script for incremental load

Tmp:
Load IndexDate From [lib://XXX.qvd](qvd);

MaxTimestamp:
Load Timestamp(MaxIndexDate)as MaxDate Resident Tmp;

Drop Table Tmp;

Let VMaxDate = Peek('MaxDate', 0 , 'MaxTimestamp');

Drop Table MaxTimestamp;

LIB CONNECT TO 'XXXX';

Load * ,Today() as LoadDate,
'Incremental' as Flag;

ABC:

SELECT * FROM dbo.ABC
WHERE IndexDate > '$(vVMaxDate)';

Concatenate

Load * From
[lib://ABC.qvd](qvd)
Where not Exists(ID);

Store ABC into
[lib://ABC.qvd](qvd);

Drop Table ABC;

[MayilVahanan · Accepted solution]

Hi @Prabhu1204 

Before store statement, try like below

ABCFinal:

Noconcatenate

Load * resident ABC where Year(IndexDate) >= Year(Today())-3;

Store ABCFinal into
[lib://ABC.qvd](qvd);

Drop tables ABC, ABCFinal;