Enforcing a rule in the workflow

[maverick_70]

Hello,

I have a requirement in which I have to enforce a business rule in the workflow. The requirement is that each value in column1 should have a 'O' and 'M' value in column2. 

Column 2 has values P,O,I,B,M corresponding to values in column 1

If the value in column 1 doesn't have an 'O' and 'M' in column 2 then alteryx could throw out an error.

Your help is much appreciated

thank you.

[CharlieS · Accepted solution]

I've attached an example of how this can be achieved. The most important tool for this is the Test tool, which will error based on a condition you set. 

Let me know if you have any questions. 

[Jonathan-Sherman · Accepted solution]

This could be achieved using the test tool which can cause the workflow to error based on a condition of your choice.

           

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan