Stop if 0 records after filter

Hi All...Appreciate a quick help. below is the sample of my workflow. I am having a Filter which sometimes give 0 records. Since I'm doing various calculations in formula tool after the filter, I'm getting error when there are no record to process. Is there a way I can stop only the True anchor of the filter and not the whole workflow if the the record count is 0.

Common Use Cases

Accepted answers

csmith11

I wish I had a better answer. You can Stop tools from processing based on user input. But I've yet to find perfect solution for this question. From what I know, there still is not a method of stopping tools from processing based on values in workflow.

Here a work around for you scenario: Simply Add a text input tool with required field to Prevent any Errors the Fields can be blank, you'll just need to inject them sometime after the Crosstab tool. This solution ensure your fields exist and prevents the errors you are seeing. See Example Below.

All comments

csmith11

There is a macro approach see here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Disable-part-of-workflow-if-no-filter-returns-False/td-p/700496

But its still not the simple turn section of workflow off option we are waiting for.

hemant86

Thanks @csmith11 . Does the text Input needs to have data as well along with fields. Its throwing the same error without data

hemant86

I got the error now. I had to place the text input before Transpose. Thanks @csmith11 for the workaround

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703