Render Tool - Output Multiple Tabs to One Excel

[don_searls]

I would like to see the same functionalitly that the Output Tool has in the Render tool.  In the Output Tool, you can specify the Excel Worksheet along with the Sheet Name that you want to output too.  Meaning Same Worksheet, different tab:

     C:Output FilesExample_Worksheet.xlsx|Report_1
     C:Output FilesExample_Worksheet.xlsx|Report_2

This functionality is not currently available in the Render Tool and would be very useful and cut out some manual operations on the back end that requires us to copy/paste from one file to another.

I tried using the Section Break technique that was offered as a suggestion, but it did not perform what I needed.

[allanfjpmc]

@chris_cleckner, thanks a lot! That was super helpful!!!

[Tanujit]

Hi @chris_cleckner,

Thanks for your details. I am also looking for the similar kind of solution, which can help me to create two tabs in excel output using the render tool. However I have followed your method. For me it came into a same tab and the part one after another from top to bottom. Also header is not flowing into the final output.

Sorry my question might be silly, but I am new to this tool so exploring using community comments. That would be really helpful if you can share a sample workflow.

[williamg]

I've started using Alteryx this year, and I love the functionality. But I've been spending most of my time with formatting more than I want. For my current project, I need to format the Excel headers, so I need the render function. However, I can't use the render function, because I am adding it to an existing sheet and have different formats for each tab. It seems like this is a old post. But if anyone has a work around, please message me.