extraction of files dynamically

[Nithin007]

interview question:

i need to extract files(Table structure is same) dynamically

if i have 5 excel files in January

and 4 files in February

every month i will get multiples files ,then what is the script that we should write to implement this?

[micheledenardi]

Are the files in the same location? Which are the files names?

Generally speacking you can replace the file name with a * asterisk to load all xlsx in a specific location.

LOAD *
FROM [lib://BaseFolder/3.DEV/_Temp/]*.xlsx
(ooxml, embedded labels, table is Sheet1);