Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
try with filesize function before loading
filesize( 'somefile.xls' ) // 0 or null = doesn't exist
here an example