topic Re: Reload new data in QlikView

Reload new data

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

Guys,

I have two dimensions,

1. Customer

2. Mapping

Whenever the QVW is reloaded, new customer can be added and also mapping.

For these two dimensions, there are some conditions

1. New Customer table needs to be reloaded once per week and

2. Mapping table has to be reloaded once per day.

Can we achieve this? If yes, please suggest an idea and also I need to do this reload using windows task scheduler, since I'm using personal edition of QV.

Re: Reload new data

tomasz_tru — Tue, 01 Aug 2017 12:04:59 GMT

You dan store Your data into separate QVD files and use those by the final QV application.

Re: Reload new data

Anonymous — Tue, 01 Aug 2017 12:22:40 GMT

Can I use Partial reload for this scenario?

Re: Reload new data

Or — Tue, 01 Aug 2017 12:30:36 GMT

You could, but then you would have to time the model to do partial reloads every day and full reloads once a week. It would also be more fiddly to set up properly.

A QVD-based approach would be better. You could do this by splitting the loads into two QVWs (one creating each QVD) and scheduling them as appropriate, or you could read the existing QVD and decide whether or not to load fresh data based on the data / metadata of that QVD - that approach would be better if it's important for you to package this entire thing in one QVW.

Re: Reload new data

Anonymous — Tue, 01 Aug 2017 13:02:33 GMT

Thanks for your suggestion, Shoham. As suggested, I need to package this entire thing in one QVW. Could you please share in detail how to do this by script wise.

Re: Reload new data

santiago_respane — Tue, 01 Aug 2017 13:36:49 GMT

Hi Siva,

you can use a metada QVD with the last update date for each QVD and then perform de reload based on a condition for each different QVD.

The metada QVD shoud have the following columns:

*QvdName

*LastUpdate

*UpdateFrequency

In your load script you shoud check, for each QVD, if the last updated date plus the frequency es equal to the current date and then peform the reload if condition is true. After the reload is performed succesfully update you meta data QVD with the new last update date for the current QVD file.

This is a very simple and basic way to resolve your issue in one QVW file. Let me know if it helps.

Kind regards,