Simple Sequencing in one workflow

Question

Has anyone had a need to run things in sequence, especially writing to file. I am running to an issue of writing to a workbook but can only have one of my data streams write. The other fail because the file is opened. Any ideas on easily running each stream in a sequence?

SeanAdams · Answer

Hey @jdevenuti

control containers were introduced in 2023.1, which is the newest version.

If you don't have access to this - you can achieve something similar by using batch macros with only 1 batch.    Batch macros force sequencing (like Control Containers) because they do not allow Alteryx to proceed until the current iteration is done.

if you're not comfortable with Batch Macros - there's some great macro training in the academy

jdevenuti · Answer

What version was control contains introduced? Would love to use them.

ArtApa · Answer

@jdevenuti - Block Until Done will the job for you: https://help.alteryx.com/20231/designer/block-until-done-tool

However, you can also use Control Containers to orchestrate your workflow: https://community.alteryx.com/t5/Engine-Works/Control-Containers-Take-Control-of-Your-Workflow/ba-p/1109233