Get only the excel file with the latest date in its name

[bbui226]

Get only the excel file with the latest date in its name

Hi folks, hope you’re keeping well! I’m just newbie to KNIME, and it looks like I start to love this platform, I need your help with something maybe it’s easy for you but not for me I have a list of Excel files with this naming format : name_DateOfYesterday.xlsx like below. [image] are there any ideas how can I only get/load the file with latest date in its name? for the above list of files, I’d like to load only the D_22-04-2023.xlsx Thanks a lot for your help.

Hello @HansS I’m referring to your solution from this post (not sure why i cant reply in that post directly)
I tried your solution, everything seems ok untill read excel node. There is no matching variable.

Im not sure where it went wrong Could you please advise?

[elsamuel]

(not sure why i cant reply in that post directly)

This is why:

I tried your solution, everything seems ok untill read excel node. There is no matching variable.

It would be best if you uploaded your workflow and data. We can’t tell anything from a screenshot.

[Daniel_Weikert]

@elsamuel is right
Based on your second node (covert path to string) I would assume you do not have a path variable anymore so nothing to choose in the excel reader. You would need it as datatype path again. But just guessing
br