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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Looking for suggestions with Error handling in script

I have a QV load that will pick up a file from another system.

My problem is that the file in question may or may not be available. It should be ready by 9a.m. but may be delayed until later that day.

My question is two-fold

1. What would you suggest in a case statement in the script (i.e. if today's file is not there then don't do the load)

2. Adding to the complexity.... is there a way to say wait for today's file

Note: The file will have a date stamp in the file name such as

File_20100112.txt

for a file that is for January 12, 2010

1 Reply
Not applicable
Author

You could take the problem out off QV.

Have a VBS checking via FileSystemObject the existence of the file to be imported.
Only when available start the reload by qv.exe /r myfile.qvw

Thilo