How to automate monthly data reload using variable in load script ?

[claudialet]

 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 ?

[jaibau1993]

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. 

[y_grynechko]

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);