Writing Multiple Visual Layout Output to Same Excel file - different Sheets.

[Alteryxexpert]

I 'm Developing a workflow where I have used Visual layout to do certain formatting and then rendering it to a same excel files.

Actually it is 2 visual layouts which produces 2 outputs and the same needs to be rendered to a File creating two different sheets.

Visual layout 1 output - sheet 1

Visual layout 2 output - sheet 2

Is this feasible? Currently when I run the workflow , it is running successfully but the second visual layout rendering overwrites the first visual layout output sheets.

I want to write both the outputs parallelly in the same file. Please help.

[Raj]

@Alteryxexpert 
yes this is achievable
can you add the sample workflow 
will be in better position to help.

[Alteryxexpert]

For security reasons can't upload the workflow, but  can add snippet. please see the attached images

[Raj]

@Alteryxexpert 
How to Render to Multiple Named Excel Sheets - Alteryx Community

refer this.
this will work for you.

[danilang · Accepted solution]

Hi @Alteryxexpert 

Use a union tool to get your layout snippets into a single column.  Then add the sheet names and use the method outlined in @DataNath's article.

Dan   

[Alteryxexpert]

Simple Union and Render worked