Reload frequency of some specific tables in a QVD Generator

[dmohanty]

Hi All,

Suppose my QVD generator has 10 tabs which has scripts for 10 tables, reloaded at a certain point of time (Ex: 12AM) and those are stored as 10 QVDs. Clear!!!

Now my requirement is to run a specific set of tables (let table 3 and table 7) at certain fixed period of time in a day(Ex:12AM, 3AM, 6AM). At this instance no other tables will be reloaded again to save time.

Please let me know how to achive this. Please post some sample scripts/QVW for this.

Regards!!!

[narender123]

Hi,

You can create 2 Qlikview Generator .1 is scheduled(heaving table1 and table3) as you  want  3 time in day and other is daily basis.

and stored Qvd's from both generator in single location.

Thanks.

Narender

[dmohanty]

That would be simple

Can't it be done from any other ways: In one QVD generator itself? using Partial Load or with some other scripts?

[dmohanty]

I guess this can be done through Partial Reload also. I can add the ADD/REPLACE command in the specific table script.

But please let me know how to do a Partial Reload of this QVW in QMC?

Requirements should be in mind:

1. First time the QVW will undergo a full reload at a scheduled time.
2. Next time onwards the QVW will undergo Partial Reload at certain hours.

[israrkhan]

hi,

i am not sure, and not tested, but one idea coming in mind.

could you not write a if statement in script,in which you could check if time = 6 pm or 3 pm and so,

to load else dont...

[Anonymous]

indeed... if then endif

[dmohanty · Accepted solution]

I managed to achieve this using Variables like this. It is working fine. Please use.

LET vReloadStart = now();

LET vSpecialReload = 0;  //Variable for specific reload
LET vReload = 1; //Variable for common full reload

IF hour(vReloadStart) = 5   or hour(vReloadStart) = 9 then

LET vSpecialReload = 1;
LET vReload = 0;              

ENDIF