Input data from all files in a directory except the most recently created - Alteryx logs
- 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,
Very new to Aleryx (2 weeks use), I have created a workflow to parse and re-arrange the data from an Alteryx log file and have all the outputs where I want them to be using a single file. Now however when I change the input path to include all the log files in the folder (Alteryx_Log_*.log) I get an error when I run the workflow as Alteryx creates a new log file in that directory and as it is 'open' it cant be read.
My question is: Can I input the data from all the files in a directory but exclude this newly created log file? Maybe by excluding the most recently created file?
I have tried using a dynamic input and a macro but my skill level is not sufficient to know if these are suitable.
Any help would be appreciated,
Josh
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Josh
You could use a Directory tool to get all files from the log directory and then a Sort tool to sort by date created. Then add a Sample tool to exclude the first/last one and feed that into your dynamic input.
Let me know if this makes sense or it it doesn't meet your requirements.
Cheers
G
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Gilly_In_Oz I tried that before but then tried it again after your post and it worked!
Thanks for the assist,
Josh
