Discussion Board for collaboration related to QlikView App Development.
I am new in Qlikview and facing a problem in check file exist.
I have create a macro to check if file exist. and don't know how to call it out in script.
I want to do
if the xxx.qvd exist then do some incremental loading, if not exist will load all of record from an xls.
Here is my macro function:
Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists(filename) Then
result = 1
result = 0
msgbox ("not good la ...")
CheckFileExist = result
Please help ...
or if any other way to do so ?
Hi, in the Script, you can use the filetime() function to check if a file exists.
if isnull(filetime('c:\file.txt')) then
//file doesnt exists
Hope this helps you.
View solution in original post
Thanks for you help...filetime() works ..