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

Timestamp of a file


Is it possible to read the timestamp of a file? There is a folder which contains multiple files in ti. I have to read the timestamps of all the files and load it.

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

Hi,

Yes is is possible try with

Load *,

FileTime() as TimeOfFile

From excel source;

Regards

Anand

View solution in original post

4 Replies
kristoferahlin
Partner - Contributor III
Partner - Contributor III

filetime(YourFile) will give you the timestamp

Regards,

Kristofer

its_anandrjs
Champion III
Champion III

Hi,

Yes is is possible try with

Load *,

FileTime() as TimeOfFile

From excel source;

Regards

Anand

ashfaq_haseeb
Champion III
Champion III

Hi,

filetime() as Date

Will get you time-stamp of your file.

Regards

ASHFAQ

jagan
Partner - Champion III
Partner - Champion III

Hi,

Check this link

Loop through Folders and sub folders to get file names

Set vConcatenate = ;

FileList:
LOAD
'' AS SourceFile,

'' AS Time
AUTOGENERATE 0;

SET vRoot = 'C:\QV Dashboards\';


                    for each FoundFile in filelist( vRoot & '\*.*' )

                              FileList:
                              LOAD '$(FoundFile)' as SourceFile,

                              filetime('$(FoundFile)')  AS Time
                               AUTOGENERATE 1;   

                    next FoundFile


Hope this helps you.

Regards,

Jagan.