Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Not applicable
Author

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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