Incremental Load

[#1]

Dear all,

I am trying to do a increment load based on date but it is not working could you kindly help me or point where i am wrong

I have a variable

let vStartdate = date(today()-5,'YYYYMMDD');

in the QVD file i have a field OpDate in the format DD/MM/YYYY

my condition is

LOAD *

;

SQL

select X, Y, Z

FROM dbo.ABC

WHERE OpDate between '$(vStartdate)'  and '$(vprvdayop)'

Concatenate

LOAD *

FROM

(qvd)

Where Date(OpDate, 'YYYYMMDD') < $(vStartdate);

[miguelbraga · Accepted solution]

Try something like this:

let vStartdate = date(today()-5,'DD/MM/YYYY');

Table:

LOAD *

;

SQL

select X, Y, Z

FROM dbo.ABC

WHERE OpDate between '$(vStartdate)'  and '$(vprvdayop)'

Concatenate (Table)

LOAD *

FROM

(qvd)

Where OpDate < $(vStartdate);

Regards,

MB