Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Loop on binary load

My script is in two parts, a binary load that I only need loaded at the beginning of the day, and the rest of the data that I need reloaded every 20 minutes. 

Is there a way of creating a loop or something that will only reload the binary once a day first thing and the rest of the data every 20 minutes?

The binary load is a .qvw file that I am loading into a Qlik Sense app on the server so I can't load it separately and store the data as a qvd.

Labels (1)
1 Reply
jheasley
Luminary Alumni
Luminary Alumni

i would create a data model app that has loading conditions based on the time of day, then have an application layer that does a binary from that data model on every successful reload.  i use the below to make an extract application reload partially on a daily basis and in full on sundays:

Let vMode = If(Match(Weekday(today()),'Sun'),1,0);
Let vReloadType = $(vMode);
 
IF vReloadType = 1 THEN
CALL getHistory;
ELSE
CALL getUpdated;
END IF