topic Re: How to Check whether file exists before loading in QlikView

How to Check whether file exists before loading

Tue, 04 Feb 2014 21:26:55 GMT

How to Check whether file exists before loading in qvd from folder which may contain multiple file of different name.

multiple csv file is to be loaded and deleted after loading . New file can come daily or may not come causing qvd loading to fail.

Till now written code for laoding from multiple files and deleted file through macro. but showing error when file is not present in the folder.

swuehl — Tue, 04 Feb 2014 21:38:44 GMT

Please check

Tue, 04 Feb 2014 21:39:49 GMT

Hi Santosh

You can use Filelist to check the files in directory and FileSize as a check for existence of specific file

Lukasz

maxgro — Tue, 04 Feb 2014 21:42:58 GMT

from online help, hope it helps you

Returns an integer containing the size in bytes of the file filename or, if no filename is specified, of the table file currently being read.

Examples:

filesize( 'xyz.xls' )

Will return the size of the file xyz.xls.