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: 
stevelord
Specialist
Specialist

failover option for loading excel files?

Hi, Is there a failover script I could use for loading an alternate excel/csv file if an expected one is not present at reload time.  Say if a partner doesn't place a needed file in the ftp folder on a given night, I just have qlikview look over at some file in another folder rather than fail to load altogether?  (The qlikview still presents the file names clearly, so we'd know it was a day old file instead of a current file being referenced, but still have the rest of the dashboard data loaded up.)

Thanks!

1 Reply
maxgro
MVP
MVP

try with filesize function before loading

filesize( 'somefile.xls' )           // 0 or null = doesn't exist


here an example

How can I check if a file exists ?