sorting the filelist function

Wed, 05 May 2010 10:35:28 GMT

Hello all,

Can someone explain me, how the filelist function sorts the files ? by name ? by date ? by size ?

is there a way to change the default sort ?

thank you all by advance for your answers

regards

Philippe

sorting the filelist function

Fri, 20 Aug 2010 12:25:29 GMT

Hi Pvivier,

I could not find a simple answer either but gotten round the problem by loading the filenames into a table. E.g.

SET lc_QvdDeltaFiles = $(gc_OutputDir)DeltaBackUp\$(gc_TableName)_*.qvd;

// List all files in Delta files directory
FOR EACH File IN FILELIST('$(lc_QvdDeltaFiles)');
LET ln_NumOfRec = ln_NumOfRec + QVDNOOFRECORDS ('$(File)');

FileTable:
LOAD '$(File)' AS FileName,
FILESIZE('$(File)') AS Size,
FILETIME('$(File)') AS FileTime
AUTOGENERATE 1;
NEXT File;

FileTableSrt:
LOAD FileName,
FileSize,
FileTime
RESIDENT FileTable
ORDER BY FileTime desc;

// Pick at the latest file
LET LatestFile = PEEK('FileName',0,'FileTableSrt');

You can then ORDER BY anything you want. Solution is clunky but works.

Cheers.

Dave.

topic sorting the filelist function in QlikView

sorting the filelist function

sorting the filelist function