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.

[Qiu]

@atcodedog05 
I see, its about the formatting...😑

[atcodedog05]

Yup thats right 😅

[praneshsapmm]

Hi Qiu,

iam unable to open this workflow , since iam using a older version of Alteryx .

Iam using 2019.4 . 

Thanks.

[Qiu]

@praneshsapmm 
OMG, 2019.4 makes it more impossible.

I am thinking  to use preserve the formatting option but that is not available in 2019.4😐

[praneshsapmm]

Hi ,

Is there any other way of meeting the requirement .

[Qiu]

@praneshsapmm 
I am still trying but so far not luck...🤔

[AkimasaKajitani]

How about this workflow?

I output Sheet1 and Sheet2 by the Render Tool(Sheet2 is dummy)  and then overwrite Sheet2 by the Output Tool. It's working fine for me.

The procedure is below.

I output sheet1 and sheet2 by Render tool. Render tool output always "sheet1", but copy the record by Generate row as "Sheetname" Field.

And I add Layout tool and set "Vertical with Section Breaks" to Orientation.

Referring URL:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Using-Reporting-Tools-to-create-Mul...