Consider this script it may help you
if $(vFileExsist) then
load * from $(vFileName)
(ooxml,no labels,table is);
MsgBox('File Not Found') as Warning1;
To make the variable act as a Boolean value, add "not" before isnull:
LET vListQVDExists = not isnull(QVDCreateTime('File.qvd'));
Now you can use
IF $(vListQVDExists) THEN...
IF $(vListQVDExists) = 0 THEN...
Hope that makes it easier,
Is it possible to check and not to load a sheet in excel file which is not existing ?
I have a situation in which in one excel file have couple of sheets. First and second sheets are on monthly bases, but third is on quarterly base. I would like to load first two and check if third is existing . If not skip and load other sheets, if exist load all.
I attach a sample excel file.
Thanks in advance