Discussion board where members can learn more about Qlik Sense App Development and Usage.
Greetings Community Members,
We need your help in suggesting the way out to the following problem statement:
In our DW, few tables get refreshed in every 10 minutes & a text file is generated on a location confirming the completion time in every 10 minutes.
we want to develop a solution in Qliksense which will read the creation time of above text file & it is within 10 minutes cycle it will refresh the QVD.
Just in case if text file is created after 5 minutes of 10 minutes cycle it will skip the current cycle & wait for next cycle.
To Demonstrate an example:
Let's say a new cycle starts at 'DD/MM/YYYY HH:10:00'
Text file is available at 'DD/MM/YYYY HH:10:40'.. it should check if it is under current cycle.. if qualifies.. refresh the QVD
If text file is available at 'DD/MM/YYYY HH:16:00' (after 5 minutes of start of current cycle) it should skip the refresh & wait for next cycle & text file update.
It would be really helpful for me if there is any suggestion available. Thank you in anticipation.
Perhaps something like this:
LOAD If(Mod(Minute(TimeStamp#(@1,'DD/MM/YYYY hh:mm:ss')),10)<5,1,0) as DoReload FROM textfile (txt)
LET vDoReload = peek('DoReload');
If vDoReload = 0 Then