Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Extracting the source data file name

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Extracting the source data file name

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

Regards,

Gordon

2 Replies
Not applicable

Extracting the source data file name

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

Regards,

Gordon

Not applicable

Extracting the source data file name

It works perfectly. Thank you!

Regards,

Vladimir

Community Browser