WF should run even if one input not available

[skotian1289]

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" .

[CharlieS]

Hi @skotian1289 

If you're sending a file path to a Dynamic Input to load the file, I would add a Filter tool before that Dynamic Input with an expression like "FileExists([fullpath])" This function would determine if the file exists and filter accordingly. This way, if the file doesn't exists, the Dynamic Input doesn't get the record and doesn't run (also doesn't error) and you can use the false output to create the message of "file doesn't exist" for your final output. 

[skotian1289]

Hi Charlie, I used your solution and added a filter tool to find the full path however the dynamic input still failed with error "FIle not found" when the source file was removed. Is it possible for you to provide a sample WF, do i need to make sum chnages in dynamic input tab as well to get to your solution. 

Thanks

SK

[mceleavey]

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.

[skotian1289]

@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

[KRexroad24]

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