The Block Until Done tool stops downstream processing until the very last record has arrived. On output, it also ensures that only a single output stream gets records at a time. Subsequent streams will be blocked until all the records are pushed through the first.
The Block Until Done tool has no configuration.
A common scenario is that you are reading and then writing to the same file. Block Until Done ensures that the reading of the file will be closed before Alteryx tries to write.
You might also use it for writing multiple tables to an Excel file. The Excel file will only let one output tool access a single file at a time.
It will slow down execution because it requires a large amount of memory. For larger streams, it may require a temp file.
The output streams will write in the sequential order of the three output anchors.
©2017 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.