Incremental load - update data

[fatihsahin]

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]

There are many postings available to these topic: https://community.qlik.com/search.jspa?q=incremental+load&type=document

- Marcus

[fatihsahin]

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]

SET DateFormat='DD.MM.YYYY';

a:

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;