Knowing latest 10 files in QS

[Bharathi09]

Hi All,

I have 25 files

I wanna know latest 10 files from them and I want to load that latest 10 files in QS

Thanks

[Aurelien_Martinez]

Hi,

You can try a script like that.

//retrieve all files name and date

for each vfile in FileList('lib://MyLib/*.qvd')

Let vDate = FileTime('$(vfile)');
Trace $(vDate);

ListFile:
Load
'$(vfile)' as File,
Timestamp#('$(vDate)') as date
AutoGenerate(1)
;

Next vfile

//limit the first 10 by date

NoConcatenate
First 10
Load
File
Resident ListFile
Order By
date desc
;

Drop Table ListFile;

//loading data

for Each vfile in FieldValueList('File')

Load
*
From [$(vfile)](qvd)
;

Next file

[Bharathi09]

In vfile what should I give there?

Get Outlook for Android<>