Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

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
Partner

filetime(YourFile) will give you the timestamp

Regards,

Kristofer

its_anandrjs

Hi,

Yes is is possible try with

Load *,

FileTime() as TimeOfFile

From excel source;

Regards

Anand

View solution in original post

ashfaq_haseeb

Hi,

filetime() as Date

Will get you time-stamp of your file.

Regards

ASHFAQ

jagan
MVP
MVP

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.