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
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.
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
if you have too many use loping suggested by @pradosh_thakur
that URL's has full details