We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output Tool Configuration - TabName as well as Overwrite Range

cjaneczko
13 - Pulsar

I am trying to output to a variety of tabs as well as preserve the formatting range. I am able to generate the tabs correctly, but every time I run the workflow it wipes out the formatting even with the preserve formatting checked off. How can I get the range appended to the tab name. This is the current configuration of the output. I would like to add the range $A1:GG10000 after the sheet name pulled from the field called TabName. Ive tried to add the $A1:GG10000 to the end of the TabName formula but all it does is add the range as a name to the tab. It doesnt treat it as a range in the output.

 

image.png

1 REPLY 1
cjaneczko
13 - Pulsar

Nevermind. I figured a way to do it. Had to build a full path in the formula tool and use the "Change Entire Path" option in the output tool.

Labels
Top Solution Authors