Including source file name as a field in the import script

[#1]

Hi all,
I am importing from several source files, so to import from all of them in one go I'm doing something like:

LOAD @1:6 as HDR,
 @7:11 as Comp,
 @12:22 as [Doc Number],
 @23:27 as Year
FROM

However, what I'd really like to do is include the file name as a field in the script. So something like:

For Each file in D:\QlikView\Sourcefiles\
 vFilename = file.name
 LOAD @1:6 as HDR,
 @7:11 as Comp,
 @12:22 as [Doc Number],
 @23:27 as Year,
 vFilename as FileName
 FROM
 
Next

I'm guessing this isn't possible how I've written it, but does anyone know a way I can do this?
Many thanks,
Tony

[#2 · Accepted solution]

Hi,

If i understood your question, below is the code for you problem

LOAD @1:6 as HDR,
@7:11 as Comp,
@12:22 as [Doc Number],
@23:27 as Year,
filebasename() as FileName
FROM

Hope this will help you.

- Sridhar

[#3]

Thanks Sridhar, that's perfect.

cheers,

Tony