topic Re: Load script - file list in QlikView

Load script - file list

alwinsch — Fri, 09 Nov 2012 12:31:06 GMT

Hi all,

I want to load all filenames in temptable and use them for another script.

I have a very simple syntax

TEMP_FILE:

LOAD

FileBaseName() as "filename",

FileTime() as "Date_file"

FROM

;

There should be 57 records in the table.

But it shows only 3.

What am i doing wrong?

Thanks,

its_anandrjs — Fri, 09 Nov 2012 12:49:03 GMT

Hi,

From my side script runs correctley please check once from your end.

Reagrds,

Anand

alwinsch — Mon, 12 Nov 2012 07:55:25 GMT

No it does not work.

I get 2 filenames and i need some around 60.

flipside — Mon, 12 Nov 2012 08:54:15 GMT

Are the files set to hidden? These won't show.

flipside

alwinsch — Mon, 12 Nov 2012 10:39:04 GMT

No the folder and files are not hidden.

But when i create a new table i get some strange dimensions.

(please see attachment)

flipside — Mon, 12 Nov 2012 10:55:42 GMT

Okay, try this code instead if you just want the file names (this will return hidden files also) ...

For each file in FileList('C:\Users\alwinsc\Documents\QlikView\ProdStat\*')

TEMP_FILE:

LOAD

subfield('$(file)','\',-1) as filename,

FileTime('$(file)') as Date_file autogenerate 1;

Next;

Your filename will have the extension, but if you don't need it just wrap around another subfield statement with '.' delimiter.

flipside