Blob output in multiple excel workbooks based on codes in a single column

[Neelima1]

Shall we generate multiple output from blob tool based on codes in "PayGroup" column. we have different codes in paygroup column, need output in a separate workbook for each code.

Please find attached files and workflow

Thank you

[SPetrie · Accepted solution]

I think I understand the request.

You can create a different template file output by grouping on the PayGroup and creating a specific output template file for each group. 

You would use the same logic in your final output to specify which output file to send the data to based on the PayGroup.

Your template file wasnt included in the zip so I made one from the example output you shared. 

Please try this workflow and see if it does what you need.

[Neelima1]

@SPetrie 

Thank you for the timely support. workflow is generating multiple outputs now. 

[rhutchison]

This is exactly what I need. However, I will have Files based on paycode and then within those files, sheets based on GL Code (if I'm using this example).

How would I get each File's sheets to have the same formatting? I've posted my question and workflow Re: Write multiple excel files with multiple tabs ... - Alteryx Community 

Is this something you can help with?