Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 |);
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 |);
Thank you very much!