Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
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
Labels