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