Renaming multiple sheets using Layout and Render tool

Stefans9

Hi, 

I am having trouble renaming sheet names in excel output file using Render and Layout tools. I have individual Tables that I joined using union tool. In Layout tool I grouped by 2 tables (as you can see in pictures below). I used Vertical with Section breaks. 

In Output Excel file, sheet names are named. "Sheet1", "Sheet2", "0". Is there way to rename them into, Calculation, Comparison, and Ratios. 

DataNath

Hey @Stefans9, in the Formulae expressions after the Table tools, it looks like you're currently making a new, different field in each which you're giving the same name as you want the sheet name to be. Instead, you should just make a field called 'SheetName' (or something similar) in all of them and set the actual expression value to be the sheet name. That way, when you Union all of the streams together, you'll have just 2 fields - one that holds the Table reporting elements and one that holds the SheetNames, which you can then set as your Section Name and will split out into these named sheets. I wrote a blog about this a while ago with some more info, link here: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015093