Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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