dynamically naming files

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!

Output

Dynamic Processing

Accepted answers

JosephSerpis

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_Filepath_13102021.yxmd

All comments

drew9

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!

Batch Macro Ex.yxzp

JosephSerpis

Dynamic_Filepath_13102021.yxmd

laneytrax

@drew9 - Unfortunately I apparently have an outdated version of Alteryx and am unable to open your solution. Thanks anyway!

laneytrax

@JosephSerpis

Thanks! this is really helpful

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703