Block Until Done Tool

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.

Configuration Properties

The Block Until Done tool has no configuration.

Why would you use it?

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.

Things to watch out for:

It will slow down execution because it requires a large amount of memory. For larger streams, it may require a temp file.

Other Tips:

The output streams will write in the sequential order of the three output anchors.