Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

StevenWorm
New Contributor

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

Re: Store a .csv File with informations from a .qvd

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 |);

2 Replies
Partner
Partner

Re: Store a .csv File with informations from a .qvd

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 |);

StevenWorm
New Contributor

Re: Store a .csv File with informations from a .qvd

Thank you very much!