Extracting the source data file name

[#1]

Hi!

I am loading some data from multiple Excel files using the following code:

for i = 0 to 20

CONCATENATE LOAD
[Type],
[Date],
[Country],

// XXXXXXX as [Source File Name]

FROM
[Data*.xls] (biff, embedded labels, table is data$);

next

I would need to set up the field ([Source File Name]) where I would be storing the name of the each source file for each record I am loading.

Any suggestions will be greatly appreciated.

Best regards,

Vladimir

[#2 · Accepted solution]

See the use of filename() and filebasename() in the script.

Regards,

Gordon

[#3]

It works perfectly. Thank you!

Regards,

Vladimir