Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammedsohail
Contributor
Contributor

Loading data into Qlik sense from multiple excel files and sheets

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);]

Labels (1)
1 Reply
anat
Master
Master