Render Tool - Pass Dynamic Output Path + Sheet Name

Question

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 · Answer

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/1015093

sneha_bhiwagade1 · Answer

@OTrieger

Please find the attached workflow

render excel to multiple tabs sneha.yxmd

OTrieger · Answer

@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