show filename that is being read in the qlikview script

[#1]

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

[#2]

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.