topic Issue with filename in QlikView

Issue with filename

Fri, 04 Jun 2010 12:43:00 GMT

Hi everybody,

I would like to parse a repository to re-create some QVD stored in a "QVD" folder.
Here is my script:


Directory QVD;
For each qvdFile in filelist ('*.qvd')

 QVD:
 LOAD
 '$(qvdFile)' as Name,
 FileName('$(qvdFile)') as FileName,
 FileSize('$(qvdFile)') as Size,
 FileTime( '$(qvdFile)') as FileTime
 AUTOGENERATE(1);

NEXT qvdFile;

Anyway, nothing i have nothing stored in FileName ....
Can anybody help me ?

Thanks a lot for your reactivity ^^

Issue with filename

Fri, 04 Jun 2010 13:10:54 GMT

Hi,

the reason is "Autogenerate" instead of '$(qvdFile)'.

Directory QVD;

For each qvdFile in filelist ('*.qvd')

QVD:
LOAD
'$(qvdFile)' as Name,
FileName('$(qvdFile)') as FileName,
FileSize('$(qvdFile)') as Size,
FileTime( '$(qvdFile)') as FileTime
From '$(qvdFile)'
//AUTOGENERATE(1)
;

NEXT qvdFile;

Hav a nice weekend!!!

Rainer

Issue with filename

Fri, 04 Jun 2010 16:30:03 GMT

Thanks a lot it's working !