topic Using FileName() without loading all data in QlikView

Using FileName() without loading all data

matthewjbryant — Wed, 01 Jul 2015 07:32:34 GMT

I have a folder of daily Open Order extracts in QVD format. The files are named D_OO_YYYYDD. I want to create a table of all dates that are accounted for.

I could Load FileName() From D_OO_*.qvd, but then all the data is ran through for each QVD. Is there a better way?

Re: Using FileName() without loading all data

Michiel_QV_Fan — Wed, 01 Jul 2015 07:34:51 GMT

Yes:

for each vFile in FileList('your path\*.qvd')

load

'$(vFile)' as Filelistnames

autogenerate(1);

next vFile

Re: Using FileName() without loading all data

jagan — Wed, 01 Jul 2015 07:36:02 GMT

Try First option

Data:

First 10

Load FileName() From D_OO_*.qvd;

Data:

Load FileName() From D_OO_*.qvd

WHERE RecNo() = 1;

Hope this helps you.

Re: Using FileName() without loading all data

jagan — Wed, 01 Jul 2015 07:39:08 GMT

Hi,

This is working for me

Data:

First 1

Load FileName()

From D_OO_*.qvd (qvd);

Data:

Load FileName() From D_OO_*.qvd

WHERE RecNo() = 1;

Both are working, but first one is faster.

Regards,

jagan.

Re: Using FileName() without loading all data

matthewjbryant — Wed, 01 Jul 2015 07:53:51 GMT

I thought there had to be a loop! Thanks

Re: Using FileName() without loading all data

jagan — Wed, 01 Jul 2015 07:55:49 GMT

Looping will take more time. Instead use First N option. It is faster.

Regards,

Jagan.

Re: Using FileName() without loading all data

matthewjbryant — Wed, 01 Jul 2015 08:02:36 GMT

I've just tried it, but I'm finding the loop much quicker. Maybe it's because the data is stored on a networked drive and not my local PC.

Edit: Logically though, it makes more sense that the loop would be quicker as it just has to look at the file names, which it has to do anyway to load the data.