topic Qlikview Incremental Load in QlikView

Qlikview Incremental Load

agni_gold — Sat, 07 Jun 2014 15:47:48 GMT

Hi ,

I have data source which contains large amount of data ,

What i have done , i have applied incremental load on this file . But my requirement is , i want to store only new records in qvd files no previous records.

So at first step i have checked if qvd exist or not , if not then i have reload all data from data source.

in next step i have checked is qvd exist , if yes then it will find max date from the previous qvd and fetch data from data source after that date.and only new records are saved as qvd .

Fine

The problem is that when no record found after maximum date then at next time when next time this file reloads then it gives error

No date found because no data was saved inside qvd.

So this is my problem please suggest some thing.

Re: Qlikview Incremental Load

swuehl — Sat, 07 Jun 2014 16:06:57 GMT

So you are not interested in the previously loaded records, but the max date of that records? Then just store the max date into a qvd.

If no new records loaded, store the last known max date into the qvd.

Re: Qlikview Incremental Load

agni_gold — Sat, 07 Jun 2014 16:12:44 GMT

But problem is that if i store that maximum date into qvd all data will be changed.

Re: Qlikview Incremental Load

swuehl — Sat, 07 Jun 2014 17:17:19 GMT

Not really sure what you want to achieve.

Have you looked at the examples for an incremental load in the reference manual and in the QV cookbook you can download from Rob's download page?

http://robwunderlich.com/downloads

Do you want to append the new records from the database with the previously stored records from the qvd?

Then just append the data in your qvw script before writing back to the qvd

Re: Qlikview Incremental Load

agni_gold — Sat, 07 Jun 2014 17:35:02 GMT

thanks for your reply

I want only new data in my qvd file and i want to overwrite previous qvd having only new records , but problem comes when 0 records overwrites on my qvd file. in that case when incremental process runs , it goes to that qvd to find max date but it is not found.

and i cant store 0 record qvd to any where else because i have to use this qvd for another qvw file.

Re: Qlikview Incremental Load

terezagr — Tue, 10 Jun 2014 10:29:30 GMT

Have a look at this blog, it might help you to solve your problem.

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