How to Load files based on system time??

don_qlikview — Tue, 05 Aug 2014 21:31:58 GMT

Hello,

I have multiple files to load during the entire day and I want to load the files based on the system time. For example if the system time is >8:30:00 AM and <8:45:00 AM the Load A,B,C From ABC.xlsx else if the system time is >9:00:00 AM and <9:15:00 AM then Load A,B,C from DEF.xlsx. How can I do this? if anyone can help that will be great!!!

Thanks,
Don

Re: How to Load files based on system time??

maxgro — Tue, 05 Aug 2014 21:58:32 GMT

schedule every 15 (?) minutes

let time = time#(frac(now()));

let starttime = Time#(23/24);

let endtime = Time#(23/24 + 50/60/24);

if ( $(time)>=$(starttime) and $(time)<=$(endtime) ) then

trace GO ???;

ENDIF;

let str = time($(time),'hh:mm') & ' start=' & time($(starttime),'hh:mm') & ' end=' & time($(endtime),'hh:mm');

trace $(str);

let starttime = Time#(8/24 + 30/60/24);

let endtime = Time#(8/24 + 45/60/24);

if ( $(time)>=$(starttime) and $(time)<=$(endtime) ) then

trace GO load ABC;

ENDIF;

let str = time($(time),'hh:mm') & ' start=' & time($(starttime),'hh:mm') & ' end=' & time($(endtime),'hh:mm');

trace $(str);

let starttime = Time#(9/24 + 0/60/24);

let endtime = Time#(9/24 + 15/60/24);

if ( $(time)>=$(starttime) and $(time)<=$(endtime) ) then

trace GO load DEF;

ENDIF;

let str = time($(time),'hh:mm') & ' start=' & time($(starttime),'hh:mm') & ' end=' & time($(endtime),'hh:mm');

trace $(str);

topic How to Load files based on system time?? in QlikView

How to Load files based on system time??

Re: How to Load files based on system time??