Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try giving this a read and see if it helps http://www.qlikviewaddict.com/2012/02/incremental-builds-real-world.html
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
many thanks.