Error in Excel Output file when linked with Table Tool

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.

Excel output error.png

Reporting

Output

Accepted answers

Bren_Spill2

@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!

All comments

Yoshiro_Fujimori

@NehaIHG ,

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

Bren_Spill2

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

Table Tool - Render.yxmd

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_Spill2

If this helps, please mark as solution!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235