topic Re: Help in Scripting in QlikView

Help in Scripting

Tue, 19 May 2015 12:03:06 GMT

Hi All,

Is it possible to load the filenames of the files present in a folder irrespective of whether it is in csv, xls or xlsx format.

Thanks,

Asma

Re: Help in Scripting

datanibbler — Tue, 19 May 2015 12:05:42 GMT

Hi Asma,

sure it is possible. Have a look at the Filename() and related functions. You can parse through all that is inside a directory and find out the name, filetype or others.

HTH

Re: Help in Scripting

jpenuliar — Tue, 19 May 2015 12:12:13 GMT

look up an example of For Each in Help(F1) Section

Re: Help in Scripting

jpenuliar — Tue, 19 May 2015 12:13:04 GMT

FOR Each a in 1,3,7,'xyz'

LOAD * FROM file$(a).csv;

// list all QV related files on disk

SUB DoDir (Root)

FOR Each Ext in 'qvw', 'qva', 'qvo', 'qvs'
FOR Each File in filelist (Root&' \*.' &Ext)
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime
autogenerate 1;
NEXT File
NEXT Ext

FOR Each Dir in dirlist (Root&' \*' )
call DoDir (Dir)

NEXT Dir

ENDSUB

CALL DoDir ('C:')