Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with filename

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 ^^

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

Not applicable
Author

Thanks a lot it's working !