In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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