Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show filename that is being read in the qlikview script

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

10 Replies
Not applicable
Author

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.