Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Can you test in Qlikview to see if a file exists?

If a file with a specific file and path exists in Qlikview, I'd like my script to behave in one way (i.e. load in data from it and concatenate it to a table). If not, I'd like it to carry on without attempting to load in the data. In VBA, you use the function "dir" to do this. How is this done in Qlikview?

Many thanks

Steve

1 Solution

Accepted Solutions

Re: Can you test in Qlikview to see if a file exists?

LET vFileExists =isnull(FileTime('MyFile.txt'));


talk is cheap, supply exceeds demand
3 Replies
Not applicable

Re: Can you test in Qlikview to see if a file exists?

Sorry, just to clarify i meant to type "@a file with a specific filename and path"!

Re: Can you test in Qlikview to see if a file exists?

LET vFileExists =isnull(FileTime('MyFile.txt'));


talk is cheap, supply exceeds demand
Not applicable

Re: Can you test in Qlikview to see if a file exists?

Many thanks G W - this did exactly what I wanted (apart from needing a NOT inserted into the expression!). :-)

Community Browser