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.
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.
Welcome to KNIME Forum. See this wf get_the_latest_file.knwf (36.5 KB)
When you use the flow with your date, you probably have to select an other column in the String Manipulation node in order to extract the data.
List Files/Folders → Files/Folders Meta Info/ → Sort by creation date descending-> Take first one
would be my first approach if possible
Brilliant, thanks a lot for your reply, it works like magic.
Thanks a lot, that’s very helpful man
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.