Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
cspindley
Contributor III
Contributor III

help - file exists in a windows dir

help - given a file spec is it possible to determine the truth without looking, i.e. wether or not a file exists in a windows dir

Labels (1)
2 Replies
Gethyn
Creator
Creator

Try the following:

IF not isnull(QVDCreateTime([\\PATH\FILENAME.qvd])) Then

Research:

LOAD *

FROM

[\\PATH\FILENAME.qvd]

(qvd);

End If


Obviousley you can use file types other than .qvd but this works for me on a .qvd file.

cspindley
Contributor III
Contributor III
Author

thanks Gethyn, this is my first Q connection with another nhs person, using the site !