Generating normal output and render tool output in same file
- 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
Dear Community ,
I have this issue while trying to generate , output tool data and render tool output in same file .
Whenever i generate the output , two sheets are generated :
1. Render tool output : All ok
2. Output tool : Empty .
Can someone help me to fix this .
Thanks.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you able to post a copy of the workflow and data?
I suspect one of the configurations is overwritting the file, and thus not taking into consideration the other output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @praneshsapmm,
It works fine for me, so if you open both outputs you are able to see some content. Do you mind double-checking please? I only assigned a sheet name on the output tool and assigned some relative paths
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ..
Sorry i checked again . It is only one sheet generated with 'Sheet1' . I need two sheets with same data .
One with render and other with normal output tool .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you try this one. I have made changes and checked.
Sheet1 - render
Sheet2 - output
It was overwriting because it was writing to the same sheet. I have changed sheet in output tool to sheet2
By default render tool always writes to sheet1 its fixed
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ,
Sheet2 is generated but no data .
Attached is the excel file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried didnt seem to work properly
I want to ask.
Why exactly do you need to get a sheet from render tool and another output tool.
Render tool itself will give the same output as output when there is no formatting is applied.
You can try something like this Formatted is colored yellow.
Please check and let me know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ,
My requirement is to generate report through render tool (though i have not shown in my sample data due confidential data) and subsequent support data leading to the report in normal output .
I could generate both through render , but that would be of huge size . So trying to generate one in render and other through normal excel .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi .. have you had a chance to crack this .
Thanks.