Partial Reload by Hour of Day

[m_perreault]

Hi All,

My script has two sections which each read from a different datasource

Section 1:

Takes 10 minutes and the data is only updated once a day (overnight)

Section 2:

Takes 1 minute and updates hourly.

I'd like to set a reload task to reload this app once every hour but after a certain time of day say 7 am, I only want to reload Section 2 because Section 1 is static.

Does anyone have any ideas on how to accomplish this.

Thanks!
Mark

[juraj_misina]

Hi Mark,

in your script set up a condition to navigate script execution to corresponding section. Something like:

If(Hour(Now()<7) then
//section one
Else
//section two
EndIf

Hope this helps.

Juraj

[m_perreault]

Thanks Juraj however wouldn't this mean that after 7 the data from Section 1 will no longer be in the application?  I only want to load Section 2 after 7 but I still want all the data from Section 1 to remain.

Thanks,

Mark

[juraj_misina · Accepted solution]

Hi Mark,

in that case store results of section 1 into QVD files and load those QVD files in section two.

Juraj

[dapostolopoylos]

Try:

LOAD

*

FROM

    Section1;

IF (Hour(Now()>7) THEN

LOAD

     *

FROM

     Section2;

ENDIF;

[m_perreault]

That's the route I think I am going to take thanks Juraj