My script is loading all the xls files in a folder but I get the following error as soon as one of these files have a "(" or ")" in the filename:
"File Not Found".
Am I doing something wrong or is this a limitation of QlikView?
Thanks in advance!
let path_Alles = 'C:\XXXX\*.xls';
for each File in filelist (path_Alles)
LOAD SubField('#'&Replace([Policy No],' ',''),'.',1) as Policy,
Insured as Client,
'YYYY' as Provider
(biff, embedded labels)
Where Len(Trim([Policy No])) > 2;
May be change as SET instead of LET
Can you show the image for $(File) in text object