Input changes and links
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
