community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Input data from all files in a directory except the most recently created - Alteryx logs

Highlighted
Atom

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

Alteryx Certified Partner

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

 

Atom

Thanks @ I tried that before but then tried it again after your post and it worked!

 

Thanks for the assist,

 

Josh

Labels