How to load the data of latest date, then rename the sheet with latest data?

[My_Rebecca]

How to load the data of latest date, then rename the sheet with latest data?

Datasource:

currently I need the data of "DC TJ Inventory_20230319",

Load

******

FROM [DC TJ Inventory_*.XLSX]
(ooxml, embedded labels, table is Sheet1)
Where max(TextBetween(FileName(),'_','.') )

But this does not work. How to script this?

Then I need to rename the sheet like this, how to realize it? Many thanks.

[MayilVahanan]

Hi

After the below statement, can you please add "Trace" statement.
let vMaxFileName=Peek('FileNameDate');
Trace vMaxFileName: $(vMaxFileName);

To find the values in the variable

[My_Rebecca]

Sorry, the same error happens again......

I'm going crazy.

[My_Rebecca]

From my knowledge, I think following script is feasible, but yet not succeed.

Is it possible to make it simple and easy? thanks.