topic Incremental Load in QlikView

Incremental Load

Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: Incremental Load

miguelbraga — Thu, 15 Sep 2016 16:36:47 GMT

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