Load multiple sheets and excel files

Thu, 23 Jan 2014 13:45:42 GMT

Hi all

Posted this question before but couldnt find a complete solution.

I have multiple excel sheets and workbooks. How do I loop them? Please see attached. Could do if it was one excel file but cannot with multiple excel files.

Re: Load multiple sheets and excel files

Thu, 23 Jan 2014 14:21:16 GMT

Hi,

1) To loop on files

a) For each file in FileList('*.xlsx')

Load .... FROM $(file) ....

b) For each file in 'A.xlsx' 'B.xlsx'

same as previous

2) To loop on sheets

See the doc made by Jagan : http://community.qlik.com/docs/DOC-4452

or the following post:

http://qlikviewnotes.blogspot.fr/2008/09/loading-multiple-excel-sheets.html

Fabrice

topic Load multiple sheets and excel files in QlikView

Load multiple sheets and excel files

Re: Load multiple sheets and excel files