Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Block until done alternative solution?

TomNL
7 - Meteor

Hi,

 

In my workflow I have 4 outputs to 4 different Excel tabs, all in the same Excel workbook.

 

Often it works fine and all my 4 tabs are filled as it should be, but sometimes 1 output is written to another file. I think the option of using 'Block Until Done' doesn't work here, as all of my main 4 inputs have data that flow into 3 of the Excel tabs, see also the attached picture.

 

Is there a 'Block Until Done' alternative/solution available here?

 

Thanks!

 

 

10 REPLIES 10
cgoodman3
14 - Magnetar
14 - Magnetar

The union tip is best for when you have outputs to different tabs but the schema is consistent, for example if you want sales by state, with each state output to a different tab. 

In the case shown it looks like you have outputs with different schema to the various tabs. Try adding a select tool after the block until done tool just before your green container and connect that to the purple box, that looks like it would force each output to a different anchor on the block until done so it would prevent conflicts.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Labels