Skip to main content

Block Until Done Tool Icon Block Until Done Tool

One Tool Example

Block Until Done has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Block Until Done to stop datasets from moving downstream until the last record in the set has been processed by all previous tools. In addition, this tool ensures that only a single output stream at a time receives the completed dataset. Subsequent streams are blocked until all the dataset records are pushed through the 1st stream.

You can use the tool in these scenarios:

  • When you read and write to the same file, use Block Until Done to ensure the entire file is read before being written to.

  • When you write to an Excel file, you can use the tool to write to only 1 sheet at a time, preventing write errors.

Keep in mind that the Block Until Done tool can slow down execution because it requires a large amount of memory.

Configure the Tool

You do not need to configure the Block Until Done tool. Place the tool at the workflow location where you want to sequence various sets of data. The workflow executes the datasets in the order defined by the Block Until Done tool's output anchors.

Troubleshoot Data Stream Sequence

When 2 or more Block Until Done tools are on the canvas, Designer must evaluate which related data stream to run.

  • Designer 1st determines the order in which each tool was added to the workflow using the tool's Tool ID.

  • Designer then runs the data stream that contains the tool that was added 1st (lowest Tool ID.)

If data streams don't run in the expected order, check the Tool ID of the tools upstream from the Block Until Done tools. To check tool ID...

  1. Select the tool.

  2. In the Configuration window, access the Annotation tab.

  3. Use ID to see what number is assigned to the tool. This number indicates the order in which the tool was added to the workflow.

Separate Stream Example

An Input Data tool (ID 1) and a Text Input tool (ID 2) are placed on the canvas. Each input is connected to a Block Until Done tool. The data stream with the Input Data tool runs 1st, regardless of which Block Until Done tool it is connected to because its ID indicates that it was placed 1st.

Shared Stream Example

An Input Data tool (ID 1) is connected to a Formula tool (ID 2) and a Filter tool (ID 3.) Both the Formula and Filter tools are connected to Block Until Done tools. The Formula tool's ID is compared to the Filter tool's ID because they are the furthest upstream tools that are not shared by the Block Until Done tools. The data stream with the Formula tool runs first because its ID indicates that it was placed before the Filter tool.