Loops to load more than one excel file at a same time

[#1]

Dear Friends,

Kindly let me know your valuable suggestions for my query.

I have an application with an input box through which the user load his single excel file into the application.

Now the user wish to load more than one file at a same time to achieve some functionality, so as per my point of view I need to include a loop in my script to load more than one file at a same time.

I am new to loops in QlikView, kindly let me know your suggestions.

I have included the application for your reference, kindly let me know

Thanks so much and I appreciate your time.

Regards,

Kiru

[maxgro]

do you need a loop?

example with this

'C:\tmp\test\a*.xlsx'

you can load all a.....xlsx fiels

Product:

LOAD [Product ID],

     Product

FROM

$(Path)

(ooxml, embedded labels, table is Sheet1);

[Anonymous · Accepted solution]

'E:\qlikview\*.xlsx' in your input field and script will load all xlsz files located in the qlikview folder

[#4]

Hello Massimo,

I appreciate your time;

I need to achieve some other functionality along with this.

So as a first step, I am trying to include a loop to invoke more than one file through UI.

Thanks,

Kiru

[#5]

Thanks Kozins, I appreciate your time!

Kiru

[maxgro]

directory;

table: load '' as field autogenerate 0;

For Each vFile in FileList($(Path))

   concatenate(table)

          LOAD   *

          From [$(vFile)]

          (ooxml, embedded labels, table is Sheet1);

next;

[#7]

Thanks Grossi, it worked!!