topic Re: Help needed to write a for loop in QlikView

Help needed to write a for loop

Tue, 12 Nov 2013 06:14:28 GMT

Hi All,

Can anyone please let me know how to write a for loop statement for loading data several xml files?This XML files are located in a particular folder.

Instead of loading one by one felt it would be better to load them at one go.

Any help or guidelines in this regard is highly appreciated.

Re: Help needed to write a for loop

kaushiknsolanki — Tue, 12 Nov 2013 06:22:24 GMT

Hi,

This is the sample script to load the files from a folder.

// 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:')

I am not giving you proper solution, cause i want you to try by your own logic.

Regards,

Kaushik Solanki

Re: Help needed to write a for loop

Tue, 12 Nov 2013 06:51:39 GMT

Hi kaushik,

I believe that the example you shared is very good one. I learned new things with it.

Regards,

Vasim

Re: Help needed to write a for loop

Tue, 12 Nov 2013 08:05:06 GMT

Hi,

Two examples I have tested with Excel files:

Example 1:

for each file in FileList('*.xlsx')
Temp_Table1:
load A as ID2,
B as Number2

FROM $(file)

(ooxml, no labels, table is Feuil1);
next

Example 2 even simpler:

Temp_Table1:
load A as ID2,
B as Number2

FROM *.xlsx
(ooxml, no labels, table is Feuil1);

Fabrice