Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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