community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Save Files to Different Locations

Meteor

I have a workflow that I set up as a macro for 15+ people to use. Currently they are each pulling 10+ reports per day and they are all set to save into the same folder. I'm not sure how to set it up so that each user can save to a different folder without going in and changing the save location in the render and creating 15 different workflows. I would like to avoid making 15 different updates anytime I change something in the workflow.

Alteryx Certified Partner

Hi @Awill39,

 

I'd suggest adding a "Folder Browse" interface tool to your macro so that the user can specify their output location on the macro itself. You can configure it so that it updates the "Output File" field value in the Render tool directly. The render tool also has an option to modify the filename using a value in your data so you can also point this new interface tool to a tool (i.e. Formula) that will create the file path.

 

Hope this gives you some ideas!

 

Best,

 

Jimmy

Quasar

You could make the program an analytic app where users can choose their own output file location.

I've attached an example.

 

Flow:

Flow.PNG

 

User Prompt:

file Browse.PNG

Meteor

Sorry, I'm still a bit new to Alteryx. How would you use the Folder Browse tool in conjunction with the Render output? I have the Output mode on "Choose Specific Output File" and I am trying to use the update value tool to insert the correct file path, but I am having trouble getting it to go to a specific folder. It goes to one folder up from where I want it to save. 

Quasar

If you check out the file attached at the bottom of my comment you will find an Alteryx workflow you can follow.

Meteor

I tried and it says that I am on a previous version and it is unable to read  it.

Alteryx Certified Partner

Hi @Awill39,

 

**Per your last post, I replaced the macro with one that should would with any version 10.5+** 

 

Attached is a macro explaining. The image below describes how you'd want to configure this Action tool to update the Render tool.

 

2017-10-26_13-31-50.jpg

Meteor

Thank you very much! It's working great.

Labels