In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Input changes and links

pangersandmash
8 - Asteroid

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

1 REPLY 1
BrandonB
Alteryx
Alteryx

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. 

Labels
Top Solution Authors