Output File Naming

tgilbert

I created a workflow that will create many new worksheets from 1 excel worksheet based on a location number and automatically save them. Is there a way to make the output read the location number filter and just name the file as the number? That way I don't have to change the name for each filter since I will be outputting up to 50 worksheets at a time. I included a screenshot of my worksheet below. Thanks!

DataNath

If I'm understanding the question correctly, @tgilbert you'll want to make a batch macro for this. You'll need a list of location numbers that joins to the upside down question mark and updates the control parameter linked to your filter. This will then run an instance of the macro for all location numbers, replacing that in your filter and outputting a file for each.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

https://www.youtube.com/watch?v=NNH_K5U5r78

In your Data Output tool, you can then just take the filename from your location number field, using this option: