Loading data into Qlik sense from multiple excel files and sheets

mohammedsohail — Fri, 16 Feb 2024 17:57:01 GMT

Hi Everyone,

I am trying to load data from multiple excel files, each file has around 10 sheets and I want to load one sheet that starts with a particular name and sheet name in all these excel files is not the same but starts with Output as prefix (ex: output1, output23, output_5 etc) and file names are month_Jan, month_Feb, month_mar etc

Is there a way I can load the data at single go

[FROM [lib://Connections (vtct_sbruton)/month*.xlsx]

(ooxml, embedded labels, table is output1);]

Re: Loading data into Qlik sense from multiple excel files and sheets

anat — Sat, 17 Feb 2024 09:45:46 GMT

you have to use loop to load the data

https://community.qlik.com/t5/QlikView-App-Dev/Load-data-from-multiple-worksheets-in-multiple-Excel-workbooks/td-p/364756

topic Loading data into Qlik sense from multiple excel files and sheets in App Development

Loading data into Qlik sense from multiple excel files and sheets

Re: Loading data into Qlik sense from multiple excel files and sheets