topic Re: looping through folder file in QlikView

looping through folder file

Anonymous — Sat, 29 Mar 2014 17:20:25 GMT

Dear all,

is it possible to loop through a folder and choose only the tables with a certain prefix name ?

for example, I would consider only the table with BUFFER_ as prefix name

Help please !1

Thanks in advance

Re: looping through folder file

its_anandrjs — Sat, 29 Mar 2014 17:31:55 GMT

Load your script some thing like in location type like this BUFFER_*.xlsx if file name start with this only. By this all your tables load and concatenate with each other and make single table also if field name are same.

LOAD FieldName,

FileBaseName() as FileName

FROM

(ooxml, embedded labels, table is Sheet1);

Hope this helps

Thanks & Regards

Re: looping through folder file

maxgro — Sat, 29 Mar 2014 18:48:30 GMT

Directory;

FOR Each File in filelist ('.\BUFFER_*.xlsx')

LOAD *

FROM

'$(File)'

(ooxml, no labels, table is Sheet1);

NEXT File;

Directory;

LOAD *

FROM

BUFFER_*.xlsx

(ooxml, no labels, table is Sheet1);

Re: looping through folder file

Anonymous — Sun, 30 Mar 2014 14:55:24 GMT

Thanks very much!!

Re: looping through folder file

Anonymous — Sun, 30 Mar 2014 14:55:55 GMT

Thanks very much for your help