Error in Excel Output file when linked with Table Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NehaIHG ,
Could you attach a sample workflow where you get the error?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NehaIHG - You need to use the render tool to write to excel - see attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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!