Input changes and links

Question

Hello,

Does anyone know if there is a way to set up the input of the workflow so that it links a new file each time it is run?

I have a folder '2020' and then sub folders 'Jan', 'feb', ...etc. Within these is a 'payroll file- Jan', 'payroll file- feb' etc that is set up the exact same. Is there a way to automatically set up the file path so each time a new month is added to the '2020' folder, it will find the latest month of data?

Thanks

BrandonB · Answer

Have you looked at the Directory tool in combination with a Dynamic Input tool? The Directory tool can pull in the file paths from a directory. You then follow that up with logic that sorts the files based on criteria. Finally, you use a sample tool to pull the first record after you sort (latest file) and run it through a Dynamic Input to read in the data.