Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Macro output to different files


I have a batch macro that I outputs using a Render tool. The output contains 4 tabs. I want the batch macro to run several files then output into different files with each having the 4 output tabs. How can I do this using the Render tool or the Output Data tool? Thank you!


Create a field like [Filename] before the Render Tool that contains the filename that you want the file to be written to. You can generate this with a formula tool or pull it from the macro inputs and use Append Fields to add it to your dataset just before the Render tool.


Then configure the Render Tool like this. The Render tool will write to the Filename that is defined in the [Filename] field.


Render config.png