Render Tool - Pass Dynamic Output Path + Sheet Name

[sneha_bhiwagade1]

Hi Team,

I would like to output multiple sheets in one excel file using Render tool.

For that I need to pass the output path dynamically and also the sheet name dynamically 

Could you please help me on the same by sharing a sample workflow.

I tried but I am getting the Error below:-

Error: Render (10): The file "C:\Users\Downloads\render excel to multiple tabs.xlsx|||Sample1" is not a supported format.

Many Thanks in advance 

[OTrieger]

@sneha_bhiwagade1 

It would be nice if you would share your workflow.

In Render tool the path should not contain the sheet name as in the output data tool. The path should be only till the .xlsx.

In a Layout Tool you can define the sheet names and get the desired output that you are asking for

[sneha_bhiwagade1]

@OTrieger 

Please find the attached workflow

[OTrieger]

Here you have a very simple and clear explanation, step by step with screen shots
https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015...