WF should run even if one input not available

Question

Hello All,

My WF has 6 inputs and all are pulled using dynamic inputs from a specific directory, currently if any of the inputs are unavailable then My WF fails and does not generate the final output. Instead if any of the Inputs are not available I want the others to run and generate the final output and the one which is giving error of "File Not Found" can send out email to users saying "Input XYZ file not available" .

KRexroad24 · Answer

interesting topic and also something I am looking to try! thanks for the discussion.

skotian1289 · Answer

@mceleavey - Sorry was away for few days. About your macro will you be able to attach a sample so that I can try it on my end as well. Regards SK

mceleavey · Answer

Hi @skotian1289 ,

I've achieved this in the past by wrapping the Input tool in a macro, then placing this in a container. Do a record count from the Directory Tool to determine your file is there and use this as the control parameter. Switch the box off if the Count=0.

This allows Alteryx to pre-determine if the file exists and will close off the area of the workflow that would otherwise error.

Hope this helps,

M.