2 outputs with multiple tabs?

[joenewman]

I'm trying to output multiple reports to Excel based on email addresses. The outputs will have similar content. I want to break up each report into different tabs based on their respective 'Area of Concern'. Is there a way to output multiple files with multiple tabs in this way? 

Thanks

[ChrisTX]

When you click the Output Data tool in Alteryx, click the link for Open Example.  The section for "Write Output to Multiple .YXDB Files - Field Name" shows how to write to different files based on data found in a field in the data stream.

For Excel, the option for "Change File/Table Name" will actually change the Sheet name.  The option for "Change Entire File Path" means you'll need a field that contains the full path to each Sheet, using the format |||SheetName at the end of the XLSX file name.

Search this message board for something like "output to multiple excel sheets" for many examples.

Chris

[Raj]

you can refer this

https://community.alteryx.com/t5/Interactive-Lessons/Writing-Data/ta-p/74561

[joenewman]

Hi, I have no difficulty doing this with the Output Data tool, I'm just struggling configuring the layout and render tools to do it. Thanks.

[ChrisTX]

Have you seen these posts about the Layout and Render tools?

Community > Blogs & Podcasts > Engine Works > One File, Three Sheets, Three Different Formats

https://community.alteryx.com/t5/Engine-Works/One-File-Three-Sheets-Three-Different-Formats/ba-p/712...

Naming Tabs in an Excel Doc Using Render Tool

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Naming-Tabs-in-an-Excel-Doc-Using-Rend...

Chris