Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Yes is is possible try with
From excel source;
filetime(YourFile) will give you the timestamp
filetime() as Date
Will get you time-stamp of your file.
Check this link
Loop through Folders and sub folders to get file names
Set vConcatenate = ;
FileList:LOAD'' AS SourceFile,
'' AS TimeAUTOGENERATE 0;
SET vRoot = 'C:\QV Dashboards\';
for each FoundFile in filelist( vRoot & '\*.*' )
FileList: LOAD '$(FoundFile)' as SourceFile,
filetime('$(FoundFile)') AS Time AUTOGENERATE 1;
Hope this helps you.