Apply Sheet Name in the Render Tool

Hi,

I am having problem of providing a sheet name to a render tool and it gives me an of "invalid supported format" whenever I include it in the formula tool containing the destination of the file. Can someone to please help how to include "Page1" as its sheet name.

Here some screenshots for your reference.

file structure.PNG

file structure2.PNG

file structure3.PNG

Hoping to hear from someone.

Thanks,

Kamen

Workflow

Reporting

Common Use Cases

Accepted answers

binu_acs

@KamenRider one way of doing this

Render_Tab_Name_23052024.yxmd

All comments

Raj

@KamenRider are you adding your page 1 in this format?
"C:\Path\To\Your\File.xlsx|||Page1"

AGilbert

Try this blog post.

How to Render to Multiple Named Excel Sheets - Alteryx Community

Looks like you need to group your basic table tool upstream to have the option available in the render tool. But I only scanned the post.

Raj

@KamenRider

Here’s a simplified example of the steps in Alteryx:

Input Data Tool (connect to your data)
Formula Tool (create a new field FilePath with the value "C:\Path\To\Your\File.xlsx|||Page1")
Render Tool (set the output to [FilePath] and choose Excel format)

AGilbert

@Raj the syntax we use for the output tool does not work with the render tool. Something I didn't know until I read the blog post linked above. Thanks for teaching me something new today @KamenRider!

KamenRider

HI @Raj

I already tried that. Kindly see the error I got.

Is there any other way. Kindly show me the way please.

Kamen

Raj

@AGilbert thank you for bringing this to my attention.
@KamenRider kindky try referring to the link attached above.

AGilbert

@KamenRider The link that I posted above is the solution. In summary, you'll need to move the concatenation of the tab names further upstream (prior to the table tool). Configure the table tool to group by the tab names, add a layout tool (config: orientation = vertical w/ section breaks, section = tab names), and then send to the render tool. The blog post has great screen shots which will help.

binu_acs

@KamenRider one way of doing this

Render_Tab_Name_23052024.yxmd

apathetichell

Follow @binu_acs advice. Render creates a single excel file. You cannot specify a sheet in the tool itself - sheet creation has to be upstream in the layout tool - and you'd need the sheet in a specific column in order to use layout correcly. Often you will want to use some combination of union/summarize (or summarize/union/summarize/union - etc) to combine your report snippets in the layout you want.

KamenRider

Hi @binu_acs

Thank you for this illustration. I am able to understand well although the structure of my workflow differs. I am able to apply your example to my workflow.

Kamen

salimaelalouaji

Hello, thanks for sharing.

What if we want to output multiple renders with different sheet names, but all within the same Excel file?

When using control containers, I end up with only one sheet in the final output file—the one from the last control container.

apathetichell

Go through the training --- it addresses this specific issue. You will need to use a union tool, and a layout tool --- and then ONE render tool. ONE file. ONE render tool.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703