Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

This is practice question

How can i load multiple excel sheets in to qv at a tile

4 Replies
Anonymous
Not applicable
Author

Yes Definately,

Actually you can use for loop statement to iterate all the sheets to load all sheets to qv at a time

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Rao,

Check with this Load Multiple excel sheets using For loop

VJ
MK_QSL
MVP
MVP

LOAD *,

  FileName() as Excelnames

FROM

*.xlsx

(ooxml, embedded labels, table is [$(*)]);

Not applicable
Author