topic Re: Incremental Load in Archived Groups

Incremental Load

NavinReddy — Wed, 23 Jul 2025 14:48:52 GMT

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

Re: Incremental Load

Gysbert_Wassenaar — Sat, 24 Aug 2013 11:44:36 GMT

Remove this part of the code:

Inner Join

LOAD Number

FROM

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

(ooxml, embedded labels, table is Sheet1);

Re: Incremental Load

NavinReddy — Mon, 26 Aug 2013 09:03:05 GMT

Hi,

Update working fine

Modify and delete not working for me

Plz find the QvW

Thanks,

Rohith

Re: Incremental Load

Gysbert_Wassenaar — Mon, 26 Aug 2013 09:12:43 GMT

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

Re: Incremental Load

NavinReddy — Mon, 26 Aug 2013 10:48:05 GMT

Hi,

Update working fine

Modify and delete not working for me

Plz find the QvW

Thanks,

Rohith

Re: Incremental Load

prajuds99 — Tue, 24 Feb 2015 11:55:00 GMT

Hi Niru,

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