Simple Sequencing in one workflow

[jdevenuti]

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? 

[RSreeSurya]

Hi @jdevenuti ,

using block until done should resolve this issue. 

[ArtApa]

@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/... 

[jdevenuti]

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

[SeanAdams]

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