Get different tabs in one excel file through Render and Output tool

Question

Hello,

I'm trying to get a table in one tab using Render tool and the some raw data in another tab using output tool but only the Render table output can be seen in the resultant excel file. The aforementioned points are how I'm trying to put the output path in Render and Output tool respectively.

path\Output\File.xlsx|||Table

path\Output\FIle.xlsx|||Data

Please let me know if there's a way to get the two sheets in one excel file together.

Thanks!

saachitalwar · Answer

Hi

I tried this but the tool didn't make a difference in the output.

Is there any other way?

Thanks!

ed_hayter · Answer

Noticed the data actually didnt pull through.

This post has discussion on the same issue: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Generating-normal-output-and-render-tool-output-in-same-file/td-p/656761.

Qiu provides a hardcoded solution on page 2 of the thread.

ed_hayter · Answer

I went with a block until done as it looked like the render was occurring after the output and overwriting the whole file.

Output said to add new sheet, then switch to overwrite sheet if i want to re-run workflow.

Could also do control containers I would have thought if you are on the up to date version.

I did seem to get an error when opening the file but it seemed to open ok

test2.xlsx

Render_Output_Flow.yxzp