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.

[atcodedog05]

Hi @praneshsapmm 

I did try to find out a way. But I was not able too geta successful output without issues.

Sorry

[praneshsapmm]

No problem .:) 

[Qiu]

@praneshsapmm 
I think the problem here is that we are trying to join a Table Object with a data stream, which are different.
I am not quite sure how to overcome this, normally we generate an Alteryx Table, not to decompose it.
I came up some way but not that pretty and some hard code is involved, to read back your render out outside of the Alteryx.

[atcodedog05]

Hi @Qiu 

Did you check the output file were both sheets present and was the data proper?

Because that was the issue i was facing it was loosing data.

[Qiu]

@atcodedog05 
Yes, I did.

There was something wrong about the filed names of Render out and I fixed by use larger paper size.

1 data goes two and union together as identical.

[atcodedog05]

Hi @Qiu 

Can you share the workflow as a packaged workbook.

So that i can take a look

Thanks🙂

[Qiu]

@atcodedog05 
Here you go.

[atcodedog05]

Hi @Qiu 

Basically as per requirement both rendered output and normal output should be in sample excel as different sheets.

In your workflow thats not whats happening exactly.

In a File output.xlsx should have 2 sheets Sheet1(Rendered output), Sheet2(Normal output)

You can add a row rule to color the table so that you know its working.

And the please open the excel and check whether it has outputted properly. Because in workflow it seemed right but in file it wasnt.

[Qiu]

@atcodedog05 
thank you for the comment.
Mistake happened here, this should the one.
I attached the modifed flow and sample output here.

its nice to have someone to look at your flow!

.

[atcodedog05]

Hi @Qiu 

Yup i did see that config.

Ok let me tell you the expected output.

In a single file

Sheet1: Data with yellow coloring. This coloring would be done by table row rule and outputted by render tool.

Sheet2: No formatting outputted by output tool

These both should should be in the same file.

Once you get this output let me know😅