Store a .csv File with informations from a .qvd

[Anonymous]

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

[StarinieriG · Accepted solution]

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]

Thank you very much!