How can I get the Render Tool and the Output Data Tool to write to the same Excel file, but on different sheets?
I'm currently trying to output both the Render Tool and the Output Data Tool results into the same Excel file, each on its own worksheet. However, when I run the workflow, only the table from the Render Tool appears in the file. I'm using the Render Tool because it allows me to format the table, but I still need the Output Data Tool to write its data to a separate sheet in the same file.
@KCooper
Refer to the solution provided by @DavidP .
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-data-after-render/td-p/...
I learned something new also.
The Key here is to create the all 2 sheets with Render tool then overwrite 2nd one with Output data tool, otherwise we will get the XML error.