topic Re: Incremental load - update data in QlikView

Incremental load - update data

fatihsahin — Tue, 14 Jul 2015 14:25:13 GMT

Hi Community,

lets say I have a table where I have following structure:

Project| SubProject| Date| Value

1 2 01,07.2015 200

Than I have another filer where I have the same structure

Project| SubProject| Date| Value

1 2 15,07.2015 400

Based on that input I will delete/overwrite the data which is already in the app with the latest one.

In the application I will not see both rows only the lates one with the updated value.

Any suggestion?

Regards

marcus_sommer — Tue, 14 Jul 2015 15:00:24 GMT

- Marcus

fatihsahin — Wed, 22 Jul 2015 16:24:05 GMT

Thanks for that my Problem is more that I Need something which is overwriting the existing the data.

Most of the things which I have found are adding data but not deleting the already existing data based on a date criteria for example.

maxgro — Wed, 22 Jul 2015 17:20:09 GMT

SET DateFormat='DD.MM.YYYY';

load * inline [

Project| SubProject| Date| Value

1| 2| 01.07.2015| 200

] (delimiter is '|');

concatenate (a)

load * inline [

Project| SubProject| Date| Value

1 | 2 | 15.07.2015 | 400

] (delimiter is '|');

// load the final table with only 1 record (the record with max date) for every proj + subproj

final:

NoConcatenate load *

Resident a

where Project<>peek(Project) or Project=peek(Project) and SubProject<>peek(SubProject)

order by Project, SubProject, Date desc;

DROP Table a;