topic Re: Incremental load in qvd's in QlikView

Incremental load in qvd's

vijetas42 — Sat, 08 Mar 2014 09:49:56 GMT

Hi everyone,

I am facing problem in incremental load within qvd's,

my scenario is first time i am doing full load but in next month i want to load only new records and last six months data among which some of the old records are updated how should i do?

Re: Incremental load in qvd's

maxgro — Sat, 08 Mar 2014 11:19:22 GMT

in online help search for incremental

Using qvd file for incremental load, case 3, insert and update (no delete)

other useful resources

Incremental Load

Incremental Load.docx

Re: Incremental load in qvd's

vijetas42 — Mon, 10 Mar 2014 07:35:42 GMT

My script is,

SET vExecTime=0;

SET v6MonthsBack=0;

t1:

LOAD LastModifiedDate

FROM D:\Qvds\cnt.qvd(qvd) ;

LET vExecTime=Peek('LastModifiedDate',0,'t1');

LET v6MonthsBack=AddMonths('$(vExecTime)',-6);

Table1:

LOAD Max(LastModifiedDate) as MDate from D:\Qvds\cnt.qvd

Where LastModifiedDate < $(v6MonthsBack);

concatenate

SQL select * from dbo.country_info where LastModifiedDate > $(v6MonthsBack) and LastModifiedDate < $(vExecTime) ;

STORE Table1 into D:\Qvds\cnt.qvd(qvd);

It's giving me an error

Cannot open file 'D:\Qvds\cnt.qvd

Where LastModifiedDate < 7/3/2013' The filename, directory name, or volume label syntax is incorrect.

Table1:

LOAD Max(LastModifiedDate) as MDate from D:\Qvds\cnt.qvd

Where LastModifiedDate < 7/3/2013 what's this mean?

Re: Incremental load in qvd's

Colin-Albert — Mon, 10 Mar 2014 07:55:47 GMT

I think there is a space missing before (qvd)

My script is,

SET vExecTime=0;

SET v6MonthsBack=0;

t1:

LOAD LastModifiedDate

FROM D:\Qvds\cnt.qvd (qvd) ;

LET vExecTime=Peek('LastModifiedDate',0,'t1');

LET v6MonthsBack=AddMonths('$(vExecTime)',-6);

Table1:

LOAD Max(LastModifiedDate) as MDate from D:\Qvds\cnt.qvd

Where LastModifiedDate < $(v6MonthsBack);

concatenate

SQL select * from dbo.country_info where LastModifiedDate > $(v6MonthsBack) and LastModifiedDate < $(vExecTime) ;

STORE Table1 into D:\Qvds\cnt.qvd (qvd);