Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Is there an Inverted Block Until Done

francocj
5 - Atom

Is there an inverted Block Until Done?

Basically, I want to process multiple inputs via the same workflow but...

  • I want the 1st input to process through the workflow first.
  • Then the 2nd input to run through the workflow.

 

So instead of the Block Until Done, which has 1 Input and 3 Output (that run in order) in the tool, I am looking for something like 3 Inputs and 1 Output.

 

I already figured how to make the workflow provide separate Output files based on the name of each Input.

 

Any ideas?

 

5 REPLIES 5
ChrisTX
16 - Nebula
16 - Nebula

To control execution order: Try Control Containers, available in more recent versions, under the Developer group

 

 Control Container Tool (alteryx.com)

 

francocj
5 - Atom

Using Control Container means that i will have to place copies of the Workflow in separate Container Tools.

I want to avoid that as the Workflow may change.  So having multiple copies means that I have to make the changes in each copy.

Is there a way I can keep just 1 version of the Workflow?

ChrisTX
16 - Nebula
16 - Nebula

Can you post a screenshot of your workflow?  Wondering if your main logic could be moved to a standard macro, then use Control Containers to process first input, then second input.

 

francocj
5 - Atom
 

Here is an example.

  • 1st: Need to run the workflow for all the records.
  • 2nd: Need to run the workflow for the filtered records.

The initial Formula Tool creates a new column which states Unfiltered.  I am using that column in the Output Tool so it creates a file using 'Unfiltered' as part of the file name.

 

The second Formula Tool overwrites the column created by the prior Formula Tool so that instead of saying 'Unfiltered', it now says ''Filtered'. The Output Tool will include 'Filtered ' in the file name.

 

 

ChrisTX
16 - Nebula
16 - Nebula

If you post a sample workflow (YXMD file), I can help move your tools around.

 

Or here's a description:

 

You shouldn't need a Block Until Done tool.

 

Move all of these tools to a Standard Macro:  Start with your tool for Price Tests, and include all tools except for your Output tools

 

Insert the macro into your main workflow twice:  once in each of your separate streams of data.

 

Move your first output tool into a Control Container, and your second output tool into another Control Container.

 

Connect from the first macro output to:  The first control container input and to the first output tool.

 

Connect from the first Control Container output to:  the second control container input

 

Connect from the second macro output to: The second output tool (inside the second control container)

 

Chris

 

 

 

Labels
Top Solution Authors