Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulgoyal1287
Contributor III
Contributor III

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

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

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand