Tool to stop workflow stream if condition not met

[Coric002]

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. 

[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.

[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. 

[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. 

[iuryalvim]

Hi, I’m facing the same issue. Did you manage to find a solution?

Thanks