Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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