How to run a bunch of exclusive containers of an Alteryx Workflow in sequence?

[nitin_l]

How to run a bunch of exclusive containers of an Alteryx Workflow in sequence? Also, I need all the ouputs of these containers into a single file. Can I achieve this?

[danilang]

Hi @nitin_l 

You can sequence and synchronize independent containers like this

The key is the synchronizer container

Add this block just before the output of container X and just after the input of container X+1.  It includes a summary tool that counts any field to produce a single row with a Count field.  The Count function coupled with the previous Block Until Done ensure that the previous output has completed writing before passing the count record onwards.  Union this single Count record with the incoming data from your next container.  The Filter removes the row where count is not null and the Select tool removes the Count column giving you just your incoming data for the next container.  Connect this to the calculation portion of your next container.

You can chain this process to include as many containers as required.

Dan