topic Re: Incremental Load Problem in QlikView

Incremental Load Problem

NavinReddy — Thu, 11 Jul 2013 12:11:21 GMT

Hi All,

This incremental Load not updating & delete data in qvd as well as in dashboard

some one tell me what is the mistake

Data:

LOAD EventId,

ModDate,

EventDate,

Description,

Status

FROM

H:\Niranjan\EventsTable.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where ModDate >ReloadTime();

Concatenate

LOAD EventId,

ModDate,

EventDate,

Description,

Status

FROM

H:\Data.qvd

(qvd)

WHERE NOT EXISTS(EventId);

Inner Join

LOAD EventId

FROM

H:\Data.qvd

(qvd);

STORE Data into Data.qvd(qvd);

Thanks in advance

Niranjan

Re: Incremental Load Problem

Thu, 11 Jul 2013 12:28:19 GMT

i think set the appropriate format of date field ,

try according to this small example

POTENTIAL_QVD:

LOAD * INLINE [

id,name

1, dddk

2,cck

];

join

POTENTIAL_EXCEL:

LOAD * INLINE [

id,name

1, dk

2,cck

3,ab

4,cd

]Where not Exists(id);

//STORE POTENTIAL_QVD into D:\POTENTIAL_QVD

Re: Incremental Load Problem

Gysbert_Wassenaar — Thu, 11 Jul 2013 12:57:04 GMT

Incremental loading doesn't delete records afaik. That would destroy your history. See this blog post for the easy way to do incremental reloading.