Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks!
I have an excel file with multiple sheets, which I want to load in Qlikview. I suppose the best way is to use the ODBC load (I am very new to Qlikview), which is not working for me; error screen shot -
Thanks in advance!
Please refer the following thread,
Thanks for the quick response Ali! My question still remains unanswered though, I have 1 excel file with many sheets in it...........
This error comes out when we are checked all at a time only. So, You should do separate sheets only.. I would ask you to explain little more?
Hi,
You have to upload the excel sheet having said with only one sheet tab at a time. otherwise you will get this error.
Aditya,
If the sheets in your Excel file have the same columns names, you can load it to QlikView as shown below.
Here, I am loading data from a single Excel file (with multiple sheets) into a file named RentalActivity2015.
The loading statement is the same the only thing changing is the sheet name that needs to be loaded. (Jan, Feb, etc, etc) . Since all sheets have the same columns names, QlikView will automatically concatenate the data.
Thanks Miguel!