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.
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: