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

[markella92]

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

[andrey_krylov]

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

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