This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I asked a similar question with regards to dynamic outputs which was extremely helpful.
Is there a way make the input a file inside a folder. I'm working with a single Excel file but the name of it will change on a weekly basis (e.g Financial results - WC date). Is there a method if building an input which would function without having to change the file input each week?
Use the Directory tool to load the list of files in the folder, sort on creation time and sample the latest one only. If you know the SheetName, for instance, Sheet1, then add it to the Fullpath and use the Dynamic input tool to load it.