Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Sheets with Same column names in QlikSense

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.

1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

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.

View solution in original post

5 Replies
marcohadiyanto
Partner - Specialist
Partner - Specialist

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,

Chanty4u
MVP
MVP

try this

sample:

LOAD

Country,

Project Code,

Headcount,

Sales,

Expenses,

Budget,

FROM [lib://ExcelsMulti/*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Not applicable
Author

Hi Marco,

Thank you. Unfortunately the discussion link goes to a closed group

Regards,

MSK

ToniKautto
Employee
Employee

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.

Not applicable
Author

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