Dynamic Input Path Name based on date

[sandrasuresh80]

Issue Description :- 

Can we have dynamic input file path names. For example : - 

Lets say my file name varies everyday based on the week start date. For example this week it would be named Sandra_2024-02-12.xlsx(this Monday) and next week it would be named Sandra_2024_02_19.xlsx(next Monday) and so on. 

Is there a way instead of manually changing my file name every time can I name it in Alteryx with a variable. So lets say the variable is x defined as datetimetoday() and then i can use this variable in the input file path in alteryx as follows :- 

Sandra_x.xlsx

So if the alteryx run is scheduled every monday it will automatically pick my file name without having to go change it in the input path every time. 

Kindly let me know if there is any way to do this. 

[aatalai · Accepted solution]

Use the file directory tool, and then use the filter tool function to be select the most recent monday, would that help?

[sandrasuresh80]

Thanks a lot for the quick response. This works. 

[aatalai]

Pleasure :)