topic Incremental load without timestamp in QlikView

Incremental load without timestamp

khadeer — Tue, 08 May 2012 18:26:52 GMT

Hi,

Is it possible to do incremental load without using timestamp

Thanks in advance

Incremental load without timestamp

rbecher — Tue, 08 May 2012 18:39:59 GMT

Hi,

of course! It depends on the information you have to determine new or changed records.

- Ralf

Incremental load without timestamp

rbecher — Tue, 08 May 2012 18:52:48 GMT

This is not a QlikView related question.

You should ask yourself "How can I determine the new or changed records in my database (or files) to load the delta into my QlikView app?"

In one situation there is a flag on the record if it's new or changed. In other situation it is a timestamp. In third situation it is a higher ID value than already loaded. Just to give a few examples.

So, at the end it depends on your situation what you want to accomplish.

Incremental load without timestamp

khadeer — Tue, 08 May 2012 18:56:11 GMT

Thank u