Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am quite new to the QlikSense.
I have an excel file with multiple sheets (yearly data) say 2005, 2006, 2007, 2008, .... All worksheets have the same column names. I would like to upload the entire file at once. I am unable to load the data AS IS since the same columns appear in other sheets.
e.g.:
Sheet name is 2010
columns are as follows:
Country
Project Code
Headcount
Sales
Expenses
Budget
...
then the sheet name 2011
columns are the same as 2010, i.e.
Country
Project Code
Headcount
Sales
Expenses
Budget
...
Please guide me. Thank you in advance.
Note: I checked for answers from previous discussions, but unfortunately I found one that pertains to QlikView and not for QlikSense.
I do not really understand what problem you are facing, can you please elaborate?
- Do you get an error?
- Is the data not loaded accurately?
- Do you get a synthetic key?
A sample of the script and data load log would perhaps help to understand what issue you are facing. A sample QVF would also be good as supporting material.
Note, I moved this thread to the Qlik Sense section of community.
Hi,
you can use this Loading Multiple Excel sheets for your reference.
steps for Qlik Sense :
1. you create data connection to your excel
2. creating script for loop the excel.
3. insert script load from excel.
Regards,
try this
sample:
LOAD
Country,
Project Code,
Headcount,
Sales,
Expenses,
Budget,
FROM [lib://ExcelsMulti/*.xlsx]
(ooxml, embedded labels, table is Sheet1);
Hi Marco,
Thank you. Unfortunately the discussion link goes to a closed group
Regards,
MSK
I do not really understand what problem you are facing, can you please elaborate?
- Do you get an error?
- Is the data not loaded accurately?
- Do you get a synthetic key?
A sample of the script and data load log would perhaps help to understand what issue you are facing. A sample QVF would also be good as supporting material.
Note, I moved this thread to the Qlik Sense section of community.
Hi Toni,
I figured this out. The error was due to synthetic error. I had to break the associations among multiple sheets. Thank you.
Regards,
MSK