Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am reading multiple files in my qlikview load script like this
load *
from \\myserver\Files\TaskResult_*.xml (XmlSimple, Table is [Root])
There are hunderd of files in this directory. However, during one of the read, the script throw an error
General Script Error
I want to findout which file is it and what kind of data is inside this file. Since there are hundrd of files inside this directory, I want to know exactly which file is it. The Qlikview log only shows \\myserver\Files\TaskResult_*.xml (XmlSimple, Table is [Root])
Is there anyway to show which file is actually being read by the qlikview script?
Shah
If you use something like:
For Each vFile in filelist('..\External Data\*.xlsx')
trace $(vFile);
TEMP1:
LOAD
....
...
FROM
$(vFile)
(ooxml, embedded labels, header is 4 lines, table is Costs);
NEXT vFile;
then you will see the file name for each file in your processing log. even if the script fails.