Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
AllData:
LOAD SubField('#'&Replace([Policy No],' ',''),'.',1) as Policy,
Insured as Client,
'YYYY' as Provider
FROM
$(File)
(biff, embedded labels)
Where Len(Trim([Policy No])) > 2;
next File
What about
...
FROM
[$(File)]
(biff, embedded labels)
Where Len(Trim([Policy No])) > 2;
try like below
Hi Veneeth
Thanks for the reply.
Unfortunately, if I change that line nothing gets loaded (loads of errors).
May be change as SET instead of LET
Hi Anil
Tried it with a SET with and without the [ ] but I get the same result as before.
Can you show the image for $(File) in text object
What about
...
FROM
[$(File)]
(biff, embedded labels)
Where Len(Trim([Policy No])) > 2;
Thanks Stefan - Work like a charm!
Was almost looking for batch renaming software!
Cheers