Incremental Load Problem

[NavinReddy]

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

[#2]

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

[Gysbert_Wassenaar]

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