topic Load different sheets from on Excel file in QlikView

Load different sheets from on Excel file

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All, Im new to Qlikview and i have the next requeriment and question,

I have a Excel with 3 sheets, every sheet have a different name, different tables and data,

but they all have a column in commun; How can i load the whole excel to qlikview, by the whole i mean all the date

and different tables, and try to enlace them or make a reference with the coloumn in commun

Re: Load different sheets from on Excel file

devarasu07 — Thu, 18 Jan 2018 19:22:33 GMT

Hi,

have you tried this method?

Load Multiple excel sheets using For loop

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

Thanks,

Deva

Re: Load different sheets from on Excel file

Anonymous — Wed, 24 Jan 2018 19:49:55 GMT

Yes, I alrdy try that and many other solutions i found arround the community, but the problem is that in every solution the data in the excels or in the sheets is the same

example

sheet 1 :

name email phone numbre

andres andres@blabla.bla 45684

sheet 2 :

name email phone numbre

juan juan@blabla.bla 45878

but in my excel I have different data in all the sheets, different coloumns , different sheets names, etc

nothing in commun, only 1 data that is the same but in different format.

So the only solution I found for now was to export everything to a Base data and join the tables via FK

and load them with the odbc drive in qlikview, but no idea how to do it based on excel.

btw thanks for the quick answer