Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is an Excel file that will be updated every month
FROM [lib://SourceFiles/MONTHLY_DATA_2019-10-22.xls]
(biff, embedded labels, table is [Excel Output$]);
Next month's data file will be:
FROM [lib://SourceFiles/MONTHLY_DATA_2019-11-22.xls]
(biff, embedded labels, table is [Excel Output$]);
How do I assign a variable to it so that the during the load it will automatically search for any Excel file named *MONTHLY_DATA and load it from source files ?
Hi!
If you need to load all excel files, then use
Load
Whatever
FROM [lib://SourceFiles/MONTHLY_DATA_*.xls]
(biff, embedded labels, table is [Excel Output$]);
Regards,
Jaime.
Hey,
let v_Month = num(month(Today()));
LOAD
"Month",
Value
FROM [lib://Desktop/MONTHLY_DATA_2019-$(v_Month)-22.xlsx]
(ooxml, embedded labels, table is Sheet1);