Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to give reload schedule in qlik sense through load script and not in QMC ? I want to control the load through script level
You can store the time and/or date in a text file through the STORE statement. Then you can have a small load script being run every minute, five minute, 10 minute, hour or whatever kind of resolution you need to check if the time in the text file has arrived or been passed and then run the rest of it's load script or exit (and wait for the next check interval).
// Load script that controls when a script should start:
vTimeToStart = Date(Today() + 1/24); // in an hour
TIMETOSTART:
LOAD * INLINE [
TimeToStart
$(vTimeToStart)
];
STORE TIMETOSTART INTO LIB://myScriptFolder/TimeToStart.txt (txt);
_______________________________________________________________________
// The load script that are scheduled to check every nth minute, hour or whatever interval
TIMETOSTART:
LOAD
*
FROM
LIB://myScriptFolder/TimeToStart.txt (txt);
vTimeToStart=Peek('TimeToStart','TIMETOSTART');
WHEN vTimeToStart<=Now() EXIT SCRIPT;
$(must_include=LIB://myScriptFolder/TheRealScript.qls);
This can of course be extended to write the name of the script that should be run so you can have a generic check and start routine instead....