Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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!
Solved! Go to Solution.
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://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:
