How to display the name of file being loaded

[GanCW]

I have a code that load excel file using wildcard

LOAD

....

FROM [lib://Payment Data/Payment Data *.xlsx]

How can I display the name of the file being loaded in the log file using TRACE commend ?

[Vegar · Accepted solution]

I don't think you can fetch the name to be displayed by trace command when using the wildschar method .

An alternative is to loop your files like below. It will five you more freedom to perform controls or display traces between each file iteration.

For each _file in FileValueList('lib://Payment Data/Payment Data *.xlsx')

Trace $(_file);

Load ... From [$(_file)];

Next _file

[Dalton_Ruer]

Workaround is save the FileName() value into a field in your table, Peek at it, then remove it after you are done reading the files.

[GanCW]

Thanks for the suggestion.

[GanCW]

Thanks for suggesting another way of doing this !