Incremental Load

[MK_QSL]

I have sales file for which I need to do incremental load.

While doing incremental Load, need to consider NEW RECORDS as well as update in existing record’s Despatched Column.

Sample file enclosed. Let me know what is wrong in this script… There are two worksheet in excel file...

[MK_QSL]

I Know but this is not the permanent solution. Business is growing and need to have better way to deal with this.

[stevedark]

You may want to see this post on Incremental Load:

http://www.quickintelligence.co.uk/qlikview-incremental-load/

And this one on processing source files to QVD equivalents, so the source is only processed once:

http://www.quickintelligence.co.uk/convert-drop-folder-files-qvd/

The post focusses on CSV files, but could easily be adapted to work over QVD files.

Once you have the QVD's doing WHERE EXISTS statements to replace old rows by loading the files from newest to oldest but only each ID once should work.  If there is no unique ID you will need to create one by concatenating (or creating a Hash of) a number of fields.

Hope that helps,

Steve

[sunilkumarqv]

Hi Manish,

try to change Dispatched Date formate I think both of  Invoice Date and    Dispatched Date conflicting so possibly

it works in that way I guess .