Generating normal output and render tool output in same file

[praneshsapmm]

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.

[echuong1]

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.

[praneshsapmm]

Hi ,

Here it is attached .

Thanks,

Pranesh

[AngelosPachis]

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

[praneshsapmm]

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 .

[atcodedog05]

Hi @praneshsapmm 

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 😀👍

[praneshsapmm]

Hi ,

Sheet2 is generated but no data . 

Attached is the excel file.

[atcodedog05]

Hi @praneshsapmm 

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.

[praneshsapmm]

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 .

[praneshsapmm]

Hi .. have you had a chance to crack this . 

Thanks.