Free Trial

Alteryx Designer Desktop Discussions

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

Multiple output sheets - Different sheets each time I run the workflow

ThanyaWells123
6 - Meteoroid

I have data which contains tasks, which team members work on. There is a column in my data called “assigned to” with the help of this column. I want to create Sheets in my output file with Team Members names. However, in some cases, some team members will not be available. In such a case. There will be no task assigned to them In this case, the output file should not create a sheet for this team member, how do I go about doing this? 

2 REPLIES 2
binuacs
21 - Polaris

@ThanyaWells123 you can use the output tool to achieve this . Sample workflow attached

image.png

ThanyaWells123
6 - Meteoroid

Hi! I am using the output tool and configuration to overwrite sheet or range. I have have already created sheets manually in the output with the Team Members name.

example today I have 5 team members working Jack,Jim, John, Sharon and Michelle. When I run the workflow it should create 5 sheets for each Team member, however the next day we have only 4 Team members working Jack, Jim, John and Michelle when I run the alteryx file it should create only 4 sheets with each of their names. How do I configure my output tool to get this result

Labels
Top Solution Authors