Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Yes is is possible try with
Load *,
FileTime() as TimeOfFile |
From excel source;
Regards
Anand
filetime(YourFile) will give you the timestamp
Regards,
Kristofer
Hi,
Yes is is possible try with
Load *,
FileTime() as TimeOfFile |
From excel source;
Regards
Anand
Hi,
filetime() as Date
Will get you time-stamp of your file.
Regards
ASHFAQ
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.