Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Generating normal output and render tool output in same file

praneshsapmm
8 - Asteroid

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 . 

 

praneshsapmm_0-1603805293220.png

 

 

Can someone help me to fix this . 

 

Thanks.

 

26 REPLIES 26
echuong1
Alteryx Alumni (Retired)

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
8 - Asteroid

Hi ,

 

Here it is attached .

 

Thanks,

Pranesh

AngelosPachis
16 - Nebula

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
8 - Asteroid

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
22 - Nova
22 - Nova

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

atcodedog05_0-1603813275517.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

praneshsapmm
8 - Asteroid

Hi ,

 

Sheet2 is generated but no data . 

 

Attached is the excel file.

atcodedog05
22 - Nova
22 - Nova

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.

atcodedog05_0-1603818857590.png

Please check and let me know.

praneshsapmm
8 - Asteroid

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
8 - Asteroid

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

 

Thanks.

Labels
Top Solution Authors