community
cancel
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

Atom

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.

Quasar

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

 

join to multiple sheets in excel.png

Meteor

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