Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
meimagine
Contributor
Contributor

Loading data from multiple excel sheets with same column names

Hi All,

I have 4 different excel sheets and I have been loading them in QlikSense. The common column names get suffix EXPORT WORKSHEET1 . Although I change the  name of the sheet after importing, the alias remains the same. How can I change that? Thanks.

Labels (2)
1 Solution

Accepted Solutions
snidamanuri
Contributor II
Contributor II

Before importing excel sheets, If you need to change the names of the sheets must be unique in every excel file So, Qlik Sense will identify the name of the sheet can be taken as table name.

View solution in original post

1 Reply
snidamanuri
Contributor II
Contributor II

Before importing excel sheets, If you need to change the names of the sheets must be unique in every excel file So, Qlik Sense will identify the name of the sheet can be taken as table name.