Incremental Load

[NavinReddy]

Hi All,

Could some one help me,I have issue with Incremental Load,

Plz find the Code,

Im Using Personal Edition

Ship:

LOAD Number,

     Letters,

     Name,

     ModificationTime

FROM

C:\Users\Sreenivasulu\Desktop\ship.xlsx

(ooxml, embedded labels, table is Sheet1)

Where ModificationTime>=ReloadTime();

Concatenate

LOAD Number,

     Letters,

     Name,

     ModificationTime

FROM

C:\Users\Sreenivasulu\Desktop\Ship.qvd

(qvd)

Where Not Exists(Number);

Inner Join

LOAD Number

FROM

C:\Users\Sreenivasulu\Desktop\ship.xlsx

(ooxml, embedded labels, table is Sheet1);

store Ship into Ship.qvd(qvd);

Thanks in Advance

rohith

Message was edited by: Niru Niru

[Gysbert_Wassenaar]

Remove this part of the code:

Inner Join

LOAD Number

FROM

C:\Users\Sreenivasulu\Desktop\ship.xlsx

(ooxml, embedded labels, table is Sheet1);

[NavinReddy]

Hi,

Update working fine

Modify and delete not working for me

Plz find the QvW

Thanks,

Rohith

[Gysbert_Wassenaar]

If you want to update and delete too you should use the Qlikview Components library. See here for more information.

[NavinReddy]

Hi,

Update working fine

Modify and delete not working for me

Plz find the QvW

Thanks,

Rohith

[prajuds99]

Hi Niru,

Please find attached corrected version for incremental load script. Insert,update and delete is working in this version.