topic Including source file name as a field in the import script in QlikView

Including source file name as a field in the import script

Thu, 16 Sep 2010 12:29:19 GMT

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

Including source file name as a field in the import script

Thu, 16 Sep 2010 13:38:51 GMT

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

Including source file name as a field in the import script

Thu, 16 Sep 2010 16:19:20 GMT

Thanks Sridhar, that's perfect.

cheers,

Tony