topic Handling LOAD errors in QlikView

Handling LOAD errors

Joaquin_Lazaro — Tue, 08 Apr 2014 10:22:59 GMT

Hello:

I've this LOAD instruction in a script, normally it work fine

File:
LOAD *
FROM
File.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

... but when the input file is empty I get this error

Error: File extdata.cpp, Line xxxx

The input file is generated by an external app and is not possible to get the header columns without records.

Is there any way to check if the file is empty before the load sentence, or a method/sentence/prefix to avoid this error??

Thank you.

Joaquín

tresB — Tue, 08 Apr 2014 10:30:35 GMT

Try FileSize().

alexandros17 — Tue, 08 Apr 2014 10:34:41 GMT

In the script write

set ErrorMode=0;

hope it helps

its_anandrjs — Tue, 08 Apr 2014 10:45:09 GMT

You can use

NoOfRows() and Errormode function.

Joaquin_Lazaro — Tue, 08 Apr 2014 11:05:54 GMT

The answer that best suits to my problem was suggested by tresesco

myFile='file.csv'

vSize = FileSile(myFile)

if vSize = 0 then

else

endif

Thank you for all suggestions