Link to excel file that date changes daily

Question

I have files on a server that I need to link to Alteryx but the files will have a date on the end of the name. I dont want to relink the file daily and is there a way for Alteryx to link to the file based on the most current date or is there another way to do this?

Inventory_20230518

Inventory_20230519

MikeFrancis1959 · Answer

me try this and see what happens!

Thanks,

Mike

cjaneczko · Answer

Take a look at this link. You can add a RegEx tool after the Directory tool to pull out the date of the file if for some reason the newest dated file isnt the most recent. Then you can use that to key on the most recent Inventory file. I created a sample file at the bottom and the Dynamic input tool will bring in the data along with the full file path of the most recent file.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-to-dynamically-run-the-most-recent-file-in-a-file-folder/ta-p/24204