Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an app, i'm loading daily data from excel sheet, the user add a new excel sheet every day,
For example : in day 3 i want to be able to see the data related to the three days in my app.
How i can load all the excels ?
Thanks
You can load all at once using wildcard "*" if they are in the exact same format the will auto concatenate into one table:
Assume your files are called
mydata_20161121.xlsx
mydata_20161122.xlsx
mydata_20161123.xlsx
YourTable:
Load *
From mydata_*.xlsx
...;
Use the wildcard to substitute the variable part of the filename.
this might help
Loading from multiple Excel files and multiple sheets
There are so many threads on this subject that I am sure if you search you will find the answer 😉
You can load all at once using wildcard "*" if they are in the exact same format the will auto concatenate into one table:
Assume your files are called
mydata_20161121.xlsx
mydata_20161122.xlsx
mydata_20161123.xlsx
YourTable:
Load *
From mydata_*.xlsx
...;
Use the wildcard to substitute the variable part of the filename.
This is working...!