Do not pass the record to next tool when a condition is not met

[Shaaz]

Hi Team,

I've the below data set which says the status of workflow whether it was successful or failed by using the crew macros.

Workflow	Status
1	Success
2	Success
3	Failed

Using the above dataset, I'm trying to run another workflow which should run only when all the above 3 workflow's status is Success, out of 3, even if any workflow status is Failed, then my other workflow should not get trigger.

Here, I don't want to use Message tool for the logic.

Can you pls help me in overcoming the logic.

[gawa]

hi @Shaaz 

It seems you can just use Filter tool to judge if the data streams should go to next process or not like this.

Or, you want to run WF via command line or API? If so, it would be challenging task without Alteryx Server.

[Shaaz · Accepted solution]

Hi, I found a solution.

1. Took unique Status.

2. In Summarize tool, I did Concatenate of Status

3. In Filter Tool, I added Concat_RunStatus contains 'Fail', the False part of filter tool, I gave connection to crew macro.