Qlik Sense: Read External Trigger Text file to refresh a QVD in every 10 Minutes

[rahulgoyal1287]

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.

Best Regards,

Rahul

[Gysbert_Wassenaar]

Perhaps something like this:

tmpTime:

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

     exit script

End if