Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Server Discussions

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

unable to write to multiple sheets after join

lliberm1
7 - Meteor

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.

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

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

 

join to multiple sheets in excel.png

mmenth
11 - Bolide

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