We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

dynamically naming files

laneytrax
6 - Meteoroid

I have a workflow that runs once a month and uses the month/year to dynamically name the exported excel file. The exported file contains data for multiple offices. I have a request to add to this file an individual sheet for each office. I would like to do this all in one workflow instead of having to run 2 workflows or use an excel macro to cutup the data.

 

I have no problem dynamically naming the file using the month/year but I'm unsure how to use this master sheet and create separate tabs for each office. I don't see an option to create a file based on 2 dynamic fields. I've tried to use a block until done to save the file then access it again but I am getting errors.

 

Any help is appreciated!

2 REPLIES 2
drew9
8 - Asteroid

Hi @laneytrax ,

 

I think what you're looking for is a batch macro. In the workflow you already have, output to the master sheet as normal. Then feed in the data that makes up the file to the batch macro input, and a unique list of the offices as the control parameter. The macro will dynamically create sheets based on the Office name.

 

I've attached the example here. Let me know if you have questions!

JosephSerpis
16 - Nebula
16 - Nebula

Hi @laneytrax if you use a formula tool you can use the Month/Year field or Fields to create the file name and then use the Office data to spilt the data into different sheets. This will then create the file plus also spilt your data into different sheet i've attached an example.

 

Dynamic_Files_13102021.JPG

Labels