Changing Paths

Hi,

I am running a workflow which uses the dynamic input tool to open the latest Excel file, but sometimes people have these files open and it throws an error.

Is there a way I can create an alternative workflow incase I get an error in another tool?

Error Message

Output

Best Practices

Optimization

Accepted answers

MichalM

In which case the easiest thing to do would be to leverage the Conditional Runner from the CReW Macros pack. This will allow you to run the process looking for the latest file followed by another module picking the second latest in case the first one fails.

All comments

MichalM

@Tahir89

The driver used to access Excel files prevents multiple applications from using it at the same time so if someone has the file open, you won't be able to work with it I'm afraid.

Tahir89

What if there is another older file? Rather than reconfiguring the dynamic input tool I want to know if it's possible once an error is flagged if there's a way to make Alteryx jump on to the other flow

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262