Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

stevelord
Valued Contributor

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
MVP
MVP

Re: failover option for loading excel files?

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 ?

Community Browser