Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Store a .csv File with informations from a .qvd

Hello qlikers,

I'm loading a .qvd - File . Now I want to save only the name of the .qvd File in a .csv file. But not only the name of the file, I need also the Timestamp and the date.  The .csv should look like this:

Name of the .qvd | TimeStamp | Date

Could someone help me? How can I create a .csv file with the parameters ? Thank you in advance.

- Steven

 

 

Labels (2)
1 Solution

Accepted Solutions
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

try with something like this:

 

file:
LOAD distinct
SubField(FileName(),'.',1) AS FILE_NAME,
Date(Floor(FileTime())) AS DATE,
Time(FileTime()) AS TIME
FROM
your qvd file
(qvd);

store file into file.csv (txt, delimiter is |);

View solution in original post

2 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

try with something like this:

 

file:
LOAD distinct
SubField(FileName(),'.',1) AS FILE_NAME,
Date(Floor(FileTime())) AS DATE,
Time(FileTime()) AS TIME
FROM
your qvd file
(qvd);

store file into file.csv (txt, delimiter is |);

Anonymous
Not applicable
Author

Thank you very much!