Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load multiple Excel workbook from single excel file with multiple tables within each workbook

Hi,

Im new to Qlik and looking for solution where I have to add multiple excel workbook which includes 7-10 different types of tables however table headers are identical within each workbook.

What I'm looking:

Load all the different excel into single view and present in Pivot Table.

I have downloaded Qlik Sense Desktop ver. 3

Thanks in advance for supporting me!!!

Thanks,

mhatreraja

1 Solution

Accepted Solutions
swuehl
MVP
MVP

There are some samples here in the forum that show how you can do this (most samples are developed using QlikView, but script syntax is quite the same except for the table source adressing, so you should be able to adapt it easily).

For example, have a look at

Loading Multiple Excel Files and Multiple Excel sheets

Load Multiple excel sheets using For loop

View solution in original post

1 Reply
swuehl
MVP
MVP

There are some samples here in the forum that show how you can do this (most samples are developed using QlikView, but script syntax is quite the same except for the table source adressing, so you should be able to adapt it easily).

For example, have a look at

Loading Multiple Excel Files and Multiple Excel sheets

Load Multiple excel sheets using For loop