Load Multiple Sheets from 1 excel file

[tan_chungkam]

I have different sheets in 1 excel file.

Each sheet represent one year data.

All the column and heading are same.

How do i load all sheets in Qliksense?

Please find attached as my scripting and excel sheets name.

ScriptingExcel Sheet Name

[Channa]

use

sheet1

concatenate

sheet2

[tan_chungkam]

@Channa 

Thanks for the suggestion.

The script would be really long and so much repetitive if i have lot of sheets.

Just wonder if there any better solution such as changing the last row of script.

[pradosh_thakur]

You have to use a for loop to do that

you can check in the community and even if you find an answer for Qlikview you can change it for Qliksense

https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784

https://community.qlik.com/t5/QlikView-Scripting/Load-data-from-multiple-worksheets-in-multiple-Exce...

[Channa]

if you have too many use loping suggested by @pradosh_thakur 

that URL's has full details