How to have a control check on workflow? (Help!)

I'm looking to highlight to the user if the sum of specific column do not add up to zero.

I want to add a function where after the workflow the summarise tool does not add up to zero - it will not allow the user to output the data.

would be grateful if you could please help with any functionality that would help me achieve this (attached workflow)

Project FS - FSLI smart generator.yxmd

TB Template.xlsx

Error Message

Accepted answers

BrandonB

Take a look at the Test tool: https://help.alteryx.com/20193/designer/tools/tool-categories/developer/test-tool

You can specify that a formula must be true or else an error will be thrown in the workflow. This seems to be exactly what you are looking for. The test tool is found in the developer category or you can type the name of the tool into the top right corner search box of Designer.

Please see the following link for stopping a workflow on a condition: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Stop-workflow-on-a-condition/ta-p/19890

All comments

mat_budden

Hi mmishal001,

I have had a look see at your workflow, And I'm not to sure i'm exactly across what your trying to achieve, But we have similar types of checks in some of our workflows and all we use is a Filter Tool....

True goes to the output....

False goes Nowhere (For us its a Browse, But you could get all kinds of funky and make it email or do whatever.)

You can set multiple rules in your Filter Tool using the custom selection and writing a custom formula.

Let me know if this helps, Or If i have missed something.

Thanks

Mat

mmishal001

Hello thank you for your message.

I'm basically concerned with the last couple of tools.

Essentially, if I run my output as of the workflow attached. I would get my desired output. Just before the output tool - I've attached a summarise tool. As of now - there are two columns on the summarise tool which both add up to zero.

Here's what I'm looking for,

if the two columns on the summarise tool are not zero - I want the output tool to be either blocked or an error message popping up?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335