In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Macro output to different files

jillian
8 - Asteroid

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!

1 REPLY 1
DavidP
17 - Castor
17 - Castor

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

Labels
Top Solution Authors