Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically output to different sheet names based on a field?

AkisM
10 - Fireball
‎03-08-2020 11:36 PM

I want to output data to a pre-formatted excel, but certain rows go to different sheets. There are 50+ sheets so I don't want to make 50 streams with 50 outputs. Is there a way that I can choose sheet name based on a column that I will populate with formulas?

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor
‎03-08-2020 11:45 PM

Hi @AkisM ,

 

Yes, there is a way!

You can configure the sheet name and take it from a column using the below configuration of the output data tool.

fmvizcaino_0-1583736284857.png

 

Best,

Fernando Vizcaino

 

Reply
0 Likes
Krish_Penubarthi
7 - Meteor
‎10-14-2020 06:03 AM

I tried like you suggested, but I did not get the answer I was looking for. Please check the attached workflow.

Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels