Control Output folder through Action Tool

Question

I have a process where my user should be able to specify the output folder for the output file to be saved in.

My workflow creates a new file name every time it runs.  If in the Output Data tool, I choose "Change Entire File Path", no matter what I specify in the Action tool, the new file will be placed in the same folder where my workflow is.  If I choose Change File/Table Name, the workflow ends with an error.

Could you please help?

Attached pdf has visual copy of the issue.

Alteryx output issue.pdf

Val2018 · Answer

I do not understand your solution since the formula tool only controls the new name of the file.  It's not clear how the full path could be controlled in this variation.  I've loaded the sample WF if you can show me.

My Output to Folder.yxzp

philipmannering · Answer

I think that might be because you're updating the filepath in the Output Data Tool, but then dynamically changing it with the "Change entire filepath" checkbox ticked. Otherwise the Action Tool looks to be configured correctly. Try instead, connecting the Action Tool to the Formula Tool where you create the filepath and updating that.