This content has been marked as final. Show 2 replies
I have written a loop that checks a directory for xls files:
FOR EACH File in FileList('\\SharedDrive\Production\Qlikview\Rebate Data\*.xls')
LET vXLSExists = 1;
exit for when $(vXLSExists) = 1;
Works great. The problem is there are NO .xls files in that directory. There are a bunch of .xlsx files. I know the QlikView help says that .xls in a filelist is essentially .xls*.
Is there anyway to change it to only search for .xls?