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