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.
Need your support on the below scenario -
I've many files under my directory (as month wise) with date as suffix and I would like to read the latest date files for my alteryx workflow.
Example - Directory Path (C:\Source Files) and file names as below -
I need to read from the directory (C:\Source Files) for the latest files as input data source to the alteryx workflow.
Thanks in advance.
You can use the Directory tool to read in the filenames, then parse out the date and use these to identify the latest files.
Depending on your needs you might alternatively want to write the names of processed files as a YXDB and join these to the directory filenames to identify the delta, which will be new files.
Here's a mock up of a way to achieve this:
Thanks Neil for the mock up, when I tried to use the below solution with Directory I'm getting only one file... and also how to take resulted files as input to the WF for further steps.
Appreciate your suggestions.