Stop if 0 records after filter

[hemant86]

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.

[csmith11 · Accepted solution]

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.

[csmith11]

There is a macro approach see here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Disable-part-of-workflow-if-no-filter-...

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

[csmith11]

No problem. Mind marking as solution to help other community members know a solution/work around has been reached.