Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Timestamp of a file

Hi,

Yes is is possible try with

Load *,

FileTime() as TimeOfFile

From excel source;

Regards

Anand

4 Replies
kristoferahlin
New Contributor III

Re: Timestamp of a file

filetime(YourFile) will give you the timestamp

Regards,

Kristofer

Re: Timestamp of a file

Hi,

Yes is is possible try with

Load *,

FileTime() as TimeOfFile

From excel source;

Regards

Anand

Re: Timestamp of a file

Hi,

filetime() as Date

Will get you time-stamp of your file.

Regards

ASHFAQ

MVP
MVP

Re: Timestamp of a file

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.

Community Browser