Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
markella92
Contributor
Contributor

how load multiple Excel dynamically and tables's name for each excel is the same

hi guys, how can i load dynamically xlsx files into same folder and concatenate tables? table for each xlsx have the same name

1 Reply
andrey_krylov
Specialist
Specialist

If all files have the same structure you can load them with asterisks in the path

: LOAD * From (ooxml, embedded labels, table is Sheet1);