Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 !