Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

francofiorillo
New Contributor III

incremental load

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.

3 Replies
Not applicable

incremental load

incremental load

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
New Contributor III

Re: incremental load

many thanks.

Community Browser