Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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