This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 05-08-201307:50 AM - edited on 03-11-201909:58 AM by SydneyF
One option to output a file to multiple sheets or tabs within an Excel file is using the Output tool.
In this example, we want to create multiple sheets or tabs. We’ll have one tab per city so that all of the customers in the same city will be in the same sheet or tab.
Configure the Output tool to Change File/Table Name, and select the field to split your file by in the Field Containing File Name or Part of File Name drop-down. For this exercise, the field should be City16.
The output shows a sheet or tab per city.
On a similar note if you would like to have named sheets using the Alteryx Render tool so that you can have nicely formatted excel output with colors and other Alteryx report functionality in the excel output you can use "group by" functionality in the reporting tools along with vertical with section breaks in the final layout tool. See attached example (SheetNames.yxmd) created in 10.0.