Accessing and determining which files are to be processed from a file repository
Sometimes, data is put in shared folders across the company’s network, and we have no control over when and how that data is updated. We have some users updating files within a shared folder, and we need to keep the last updated one from a set of various versions of the same file.
This recipe will help you determine the newest files to be processed from within a folder.
Getting ready
To follow along with this recipe, use the ch1\r5 files from GitHub:
https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch1/Recipe5
If you decided to use your data to follow up on this recipe, the only thing you need to make sure of is that all your files are in one directory (and/or subdirectories).
How to do it…
- Place a Directory tool onto the canvas and point it to where your data is (in our example set, it’s on
..\DATA\).
Select *.xlsx as the File...
