Outputting a render tool to a separate sheet in excel

[Richie059]

Hey guys, so I want to output a render tool to the first sheet of an excel file and regular data to the second sheet. How can I go about doing this?

[ConnorK]

Hi @Richie059 ,

Please see the marked solution from @Jonathan-Sherman in the below think. This should help with this process.

- https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Render-to-multiple-tabs-in-1-excel-fil... 

Best,

[Richie059]

@ConnorK 

Hey thank you but I've already tried that and it isn't working. It's not even close.

[ConnorK]

Hi @Richie059 ,

Apologies I misread your question originally. In this situation it would be best to output all of the data through the Render tool so that the same excel sheet is only expecting one method of data being written to the document. Attached I have created a workflow that does this. Both the charts are on a single sheet, and the data is on separate sheet. The key to this is using "Label" fields to make sure that the charts end up on one sheet and the table ends up on the other.

Best,