community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Change Excel sheet name in file generated from Render tool

Highlighted
Asteroid

Hi,

 

The attached workflow does what I want except for 1 thing:

 

The Excel file has sheet names "sheet1" & "sheet2".

 

Is there a way to change this (without opening the file and manually changing them)

 

Ideally I want the sheet names to be the same as the field names fed into the Layout tool.

 

Alteryx_Render sheet names.JPG

 

Alteryx_Layout input_field names.JPG

 

Pulsar

I modified your workflow to define the Sheet Names in the output file. See attached, specifically the configuration of the layout tool.

 

Render tool with sheet names.png

Asteroid

@DavidPthanks very much for your help!

Labels