topic Re: How can I check if a file exists ? in QlikView

How can I check if a file exists ?

Anonymous — Thu, 27 Jun 2013 21:53:02 GMT

Dear all,

is it possible to verify if a file exists or not ?

Thanks in advance

Re: How can I check if a file exists ?

sujeetsingh — Fri, 28 Jun 2013 05:19:01 GMT

Consider this script it may help you

SET vFileName='C:\Users\Sheet.txt';

Let vFileExsist=if(FileSize($(vFileName))>0,-1,0);

if $(vFileExsist) then

Table1:

load * from $(vFileName)

(ooxml,no labels,table is[]);

Else

Load

MsgBox('File Not Found') as Warning1;

End if;

Re: How can I check if a file exists ?

sujeetsingh — Fri, 28 Jun 2013 05:21:24 GMT

you can go to following thread they will help you.

http://community.qlik.com/thread/28381

http://community.qlik.com/message/340253#340253

Hope it will help you

Re: How can I check if a file exists ?

Fri, 28 Jun 2013 05:43:49 GMT

LET vListqvdexists=isnull(QvdCreateTime('File.qvd')); // if qvd exists then 0 else -1

//if Qvd is exist then Delta loading Else Initial Loading.

Regards-Bika

Re: How can I check if a file exists ?

Anonymous — Fri, 28 Jun 2013 07:13:15 GMT

Thanks !!

Re: How can I check if a file exists ?

smoon63 — Fri, 10 Jan 2014 23:39:02 GMT

To make the variable act as a Boolean value, add "not" before isnull:

LET vListQVDExists = not isnull(QVDCreateTime('File.qvd'));

Now you can use

IF $(vListQVDExists) THEN...

instead of

IF $(vListQVDExists) = 0 THEN...

Hope that makes it easier,

Scott

Re: How can I check if a file exists ?

Fri, 20 Nov 2015 09:40:04 GMT

Hi ,

Is it possible to check and not to load a sheet in excel file which is not existing ?

I have a situation in which in one excel file have couple of sheets. First and second sheets are on monthly bases, but third is on quarterly base. I would like to load first two and check if third is existing . If not skip and load other sheets, if exist load all.

I attach a sample excel file.

Thanks in advance

Re: How can I check if a file exists ?

Anonymous — Thu, 25 Jan 2018 12:50:04 GMT

i ilke the way you formulated your answer. clear, usefull and concrete

Re: How can I check if a file exists ?

cspindley — Tue, 24 Apr 2018 15:03:56 GMT

thank you for your help with this, i am up and running again ...

Re: How can I check if a file exists ?

Kostan — Fri, 01 Oct 2021 23:54:12 GMT

You can check it with FileList():

LET vFileName='/A/B/C.D';

LET vFileExist=0;

FOR Each vFile in FileList('$(vFileName)')

LET vFileExist=1;

Next vFile;

IF (vFileExist = 1) THEN

TRACE File exists;

ELSE

TRACE File does not exist;

END IF