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
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
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.
Have you seen these posts about the Layout and Render tools?
Community > Blogs & Podcasts > Engine Works > One File, Three Sheets, Three Different Formats
Naming Tabs in an Excel Doc Using Render Tool
Chris