Getting error 'The system cannot find the specified file' on the Email tool.

[Glopez76]

Good morning, community.

Hoping that someone can help.

I have a simple workflow in Alteryx Designer that creates an output file and emails it as an attachment.  

The Formula tool creates a dynamic variable that it is used as the file name and the Email tool should identify the file to be attached based on that dynamic variable.

The file is successfully created, however, I am getting the error message 'The system cannot find the file specified'.

The AMP engine is not being used.

[Mathias_Nielsen]

Hi,

I think you need to connect the output tool to the "1" anchor in the block tool. The block until done will run 1, then 2.... Right now it is just running 2 as there is nothing to finish at 1 first. Hope this made sense :D

[Glopez76]

Hi Mathias, thank you for replying.

I made that change but the error persists. 

[Mathias_Nielsen]

Can you open the file using the DynFileName being passed to the email tool?

I am trying to figure out if it is a filename error or a workflow error

[Glopez76]

Do you mean if I can open the resulting csv file on my pc?  If so, yes, I can open it.

[Mathias_Nielsen]

Well then you could try this (See photo)

Using the control containers you can run one container after the other. Make sure to connect the containers like in the photo.

Using the control containers requires the AMP engine to be turned on

[binuacs · Accepted solution]

@Glopez76 Can you update the full path in the variable "DynFileName"  (Z:\...)then use the change entire path from the output tool

 

[Glopez76]

Thank you, @binuacs, this solved the problem.  Can you explain why this was needed, as opposed to just change the file name?

[Glopez76]

@Mathias_Nielsen, I was looking for a way to implement your design with the control containers when @binuacs suggested something that solved the problem.  I don't seem to have the 'control container' functionality for some reason but I will look into this because it actually solves another design problem I'm facing.  Thank you for your help.   

[Glopez76]

@binuacs, the workflow is running fine now, with no errors and the file is getting emailed, except that the file does not get saved in my pc now.  Is this expected when selecting the option of replacing the entire file path on the Output tool?