topic Re: Possible to check file size before load? in QlikView

Possible to check file size before load?

Tue, 16 Dec 2014 17:12:22 GMT

I am trying to load a set of XML extracts that we receive every night, however we receive empty 'shells' if no new data has been entered in the system. So what happens is we have 1KB files sitting on the server being ran and causing an error during the load. Other than setting the error mode to zero, I'd like to set up a parameter of: if the file >= 3KB, load, if not, skip.

Has anyone done this or something similar?

Re: Possible to check file size before load?

rwunderlich — Tue, 16 Dec 2014 17:54:27 GMT

Take a look at the filesize( 'xyz.xls' ) function in Help.

LET vSize = filesize(myfile);

IF '$(vSize') > 3000 THEN

LOAD * FROM myfile;

ENDIF

-Rob

Re: Possible to check file size before load?

Wed, 17 Dec 2014 01:00:31 GMT

Perfect!