Error in Excel Output file when linked with Table Tool

[NehaIHG]

Hi Users,

Whenever I join a 'Table' Tool with 'Output Tool' (excel file), on running the workflow the 'Table' tools output shows as 'Table - View Browse Tool Report Tab' and the same gets reflected in the output excel file also, instead of the output data.

Anyone can please advise how to tackle the situation and get the lines/ data in the excel output file.

[Yoshiro_Fujimori]

@NehaIHG ,

Could you attach a sample workflow where you get the error?

[Bren_Spill]

@NehaIHG - You need to use the render tool to write to excel - see attached

[NehaIHG]

Thanks Bren, it helps. Further question, does 'Render' Tool allows to select specific sheet in which output is required as as far as I understand, we can only specify the workbook name and then only 1 sheet can get created from he render tool. Which poses problem when there are multiple tabs in the same file.

Thanks for your help :)

[Bren_Spill · Accepted solution]

@NehaIHG - yes, it's possible to write to multiple sheets using the render tool. It's similar to using the Take File/Table Name From Field functionality in the Output Data tool. Instead you group by a specific filed in the Table tool, and use the Group Data option in the Render tool. See this link for detail: How to Render to Multiple Named Excel Sheets - Alteryx Community

If this helps, please mark as solution!