Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Excel Sheets with Same column names in 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.

5 Replies
chooco_co
Not applicable

Re: Excel Sheets with Same column names in QlikSense

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
Not applicable

Re: Excel Sheets with Same column names in QlikSense

try this

sample:

LOAD

Country,

Project Code,

Headcount,

Sales,

Expenses,

Budget,

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

(ooxml, embedded labels, table is Sheet1);

Not applicable

Re: Excel Sheets with Same column names in QlikSense

Hi Marco,

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

Regards,

MSK

ToniKautto
Not applicable

Re: Excel Sheets with Same column names in 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.

Not applicable

Re: Excel Sheets with Same column names in QlikSense

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