topic Re: How to update excel values using incremental load in QlikView

How to update excel values using incremental load

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I'm using excel data as input into my qv application using incremental load. If I change any cell value in excel then how to update the value in QVD file.

EX:

Date 1	Sales 2
6/4/2018	500
6/5/2018	100
6/6/2018	300
6/7/2018	700

If I change any cell value in sales column how to update in qvd file

Re: How to update excel values using incremental load

qlikwiz123 — Mon, 11 Jun 2018 17:02:39 GMT

Hi,

You have to re-run the Incremental Script every time you want to update the QVD. In case of a server, you can schedule the QVW to refresh on a schedule so that it pulls the updated values from the Excel and stores them into QVD.

Re: How to update excel values using incremental load

Anonymous — Tue, 12 Jun 2018 06:21:48 GMT

Hi,

Thank you for your reply. I can able to load new or updated records into qvd using incremental load. But If I modify any cell value (Ex: in sales column in above table ). How to update the modified value in our existing qvd.

Re: How to update excel values using incremental load

ravikumar89 — Tue, 12 Jun 2018 07:10:19 GMT

Just reload the Document.It will fetch the updated values and stores into QVD.

Re: How to update excel values using incremental load

agomes1971 — Tue, 12 Jun 2018 09:32:16 GMT

Hi,

please read this:

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

HTH

André Gomes