failover option for loading excel files?

stevelord — Wed, 03 Sep 2014 14:30:20 GMT

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!

Re: failover option for loading excel files?

maxgro — Wed, 03 Sep 2014 14:33:23 GMT

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 ?

topic failover option for loading excel files? in QlikView

failover option for loading excel files?

Re: failover option for loading excel files?