Remove worksheet name in Field

[chunlung1]

Hello! I am new to QlikSence. I receive an excel with muti-worksheet (sheet1-3) but same format like below

	Jan22	Feb22	Mar22	Apr22	May22	Jun22	Jul22	Aug22	Sep22	Oct22
A	1	1	1	1	1	1	1	1	1	1
B	2	2	2	2	2	2	2	2	2	2
C	3	3	3	3	3	3	3	3	3	3

Since there are three sheet with same header (e.g Jan22), when i tried to create a table, the header become sheet1.Jan22

I would like to just display Mar22 but not sheet1.Mar22 in the table, is there any ways to do it without manually  changing the label? Thank you!!

[PrashantSangle · Accepted solution]

can you provide little bit more information.

How you are loading data? using data load editor or data manager?

Can you share your script?

[chunlung1]

currently I am using data manager to import the excel, but i am also trying to create new connection to oneDrive, thanks!

[PrashantSangle]

cool. you are getting this error only because of data manager. Once load data from Script. you will get correct names of it.

[chunlung1]

Now that I am using load data from Script, the names is corrected, but I face another issue which the data I load is combining all value in different worksheet together!

For example, when I try to create a table, it shown more then three row (4-9 should belongs to different table in other worksheet). Is there any ways to separate the row? e.g. 4-6 should belongs to table in worksheet 2 and 7-9 should belongs to table in worksheet 3. Thank you!

Task	Mar22	Apr22	May22	Jun22	Jul22	Aug22	Sep22
A	1	1	1	1	1	1	1
B	2	2	2	2	2	2	2
C	3	3	3	3	3	3	3
-	4	4	4	4	4	4	4
-	5	5	5	5	5	5	5
-	6	6	6	6	6	6	6
-	7	7	7	7	7	7	7
-	8	8	8	8	8	8	8
-	9	9	9	9	9	9	9