incremental load

[francofiorillo]

hello

I loaded a table containing the rows of a sales document, SalesDetails whose unique key is formed by two fields: SaleDocId and Line.

in this table can be inserted rows. The old lines may be edited or deleted.

to increase the speed of loading, I would like to load only the rows to insert, modify or delete.

could you please provide me a detailed example of why I am not clear how to do?

I imagine that the procedure can be applied to each load.

[#2]

Try giving this a read and see if it helps http://www.qlikviewaddict.com/2012/02/incremental-builds-real-world.html

[rwunderlich]

Consider using Qlikview Components (Qvc).

http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html

You'll have to create a new PK field by concatenating SalesDocId & Line.

-Rob

[francofiorillo]

many thanks.