How can I identify the file/table ("...price lists - Cloud.xlsx") of a Field ("Product") that does not load because the Field is missing?

[ogatchell]

The file is one among many (50+) files loaded by the script (see point 1, 1st image). The file/table field is Product (point 2, 1st image). The load progress reports shows the load error occurring on a certain File (point 2  + ?, 2nd image), but does not show the file name.

Is there a way to automate identification of the file name, to avoid opening and closing each file in the folder to fix the error? 

[marcus_sommer · Accepted solution]

Loading data per wildcards has some disadvantages. Better would be to make such things more explicit which might in this case be done with a filelist() loop. Within it you may place a TRACE statement to show the current file and further doing a lot other useful things like implementing if-loops to check file-features and to control any ERRORMODE logic ...

Within the help is a great example of it: For each..next | Qlik Cloud Help

[ogatchell]

thanks, Marcus