topic Re: DIRLIST order in QlikView

DIRLIST order

Tue, 15 Aug 2017 15:08:00 GMT

FOR EACH VDIR IN DIRLIST('C:\')

what's the directories sort priority (name, date ...)? and can I choose it?

thanks!

Anil_Babu_Samineni — Tue, 15 Aug 2017 15:15:20 GMT

I am not done this and may be not followed you. Will you check something like this?

For Each vDir In DIRLIST('C:\')

Sample:

Load * From ....;

Concatenate

Load * from .....;

Final:

Load * Resident Sample Order By name, date;

passionate — Tue, 15 Aug 2017 15:30:06 GMT

Hi Luigi,

The load priority while loading is by name in filelist.

Regards,

Pankaj

Tue, 15 Aug 2017 17:21:39 GMT

Hi Anil,

DIRLIST provides an array of string, one for each directory in "c:\" in this example

I was wondering how these string are sorted and if I can change it

Tue, 15 Aug 2017 17:23:40 GMT

Hi Pankaj,

are you saying that both filelist and dirlist sort the array by name?

is there any way I can change this priority by date for example?

thanks

Anil_Babu_Samineni — Tue, 15 Aug 2017 17:24:54 GMT

May be explain/show how your variable looks like?