Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.