Tool to stop workflow stream if condition not met

Hello,

I have looked through the community and it doesn't seem like there is a tool within Alteryx that will stop a workstream, within a workflow, from processing while also turning off the errors for the tools within that workstream.

The issue I am running into is there are 0 records being sent down a specific steam within my workflow. Because there are 0 records the formula tools, summarize tools, and etc are throwing errors because there is no data. It would be convenient if Alteryx had a tool that if a condition was met then it would disable all tools downstream.

Workflow

Custom Tools

Accepted answers

All comments

Deano478

Hey @Coric002 you could try using the Message tool from the Developers tool tab that might get you at least to a starting point with this issue

Coric002

Hey @Deano478 I have tried but doesn't help disabling the error messages downstream of that workstream causing my whole workflow to fail. I would need to add another input to add the columns needed for the workstream for it not to fail. Would be better if Alteryx had a tool.

Deano478

Here is a simple example of how it works and as you can see it doesn't throw errors on all the tools that follow it.

Stop Message.yxmd

Coric002

I have updated your workflow to function specifically the issue I am facing.

When going through later parts of the work stream I have other tools like cross tab and etc, if those tools do not have the right variables then the columns are not created. This causes the later tools to fail like the summarize tools or formula tool etc.

Stop Message.yxmd

flying008

Hi, @Deano478

If @Coric002 use transpose + crosstab + summarize follow message tool, the error can show (Because the fields are lost).

flying008

Hi, @Coric002

If your workflow have only a path, the option maybe can for you .

Coric002

That is the issue I have about 10 paths.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703