Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

unable to write to multiple sheets after join


Assume a workflow with a join that has two of the outputs proceeding in the workflow and ultimately writing to separate excel sheets in the same excel workbook.  How is this able to be performed without error as it appears you can't incorporate a block until done tool on this split path.


I am currently having to add a formula to denote which sheet they would have gone to and union onto one sheet.  See attached screenshot.


Duplicate the join tool and put the block until done in front of it, something like this


join to multiple sheets in excel.png


You can configure the output tool to write a new sheet for every status you have. Example:Capture.PNG