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