Run the same workflow for multiple files

Question

Hello,

I have created a workflow and need to run it on multiple files. Instead of resetting the input for every file, I've tried using a wildcard to pull all files within the same folder. The output combines everything into one excel. I would like each file to have its own tab within the same excel file.

Any help?

Luke_C · Answer

Hi @adcastil

This should be a pretty straightforward exercise:

* In the input tool, make sure it's configured to take the file name as a field
* In the output tool, use that file name field as the tab name (or make a new field for your desired tab name) and configure it like the below screenshot.

philipmannering · Answer

This is a common request, that get's asked quite frequently. Here's one thread explaining how to do it,

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-multiple-tabs-within-a-single-Excel-file-based-on/td-p/507828

Or if you share some dummy data I can mock up an example on how to output to multiple sheets.