Check condition and determined what to do next

[collin924]

Hi everyone,

I've got this problem:

I have a column called 'status' with content 'OK' or 'NOK'. I want to check, if status are all 'OK' then send email to tell others you can go to next step, if status contains 'NOK', nothing will happen.

Could anyone helps me with this problem?

best,

[atcodedog05]

Hi @collin924 

You can use a filter tool for this.

If Ok, then it will go to True and send email.

If Not Ok, the it will go to False

Like below.

Hope this helps 🙂

[PhilipMannering]

The email tool will send an email for every row that's passed to it. So just filter [Status] = "OK" and pass these records to the filter tool. Remember it's an email per row of data. More information on the email tool can be found here,

https://help.alteryx.com/current/designer/email-tool#:~:text=The%20Email%20tool%20runs%20as,images%2....

and here,

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Email/ta-p/32129

Hope this helps.

Thanks

Philip

[collin924]

Hi  atcodedog05 ,

Thanks for you response but it's not what I mean.

I don't want to separate the 'OK' and 'NOK'.

I want to check all cells in 'status' and if there contains any 'NOK', the workflow will not give out any data neither the 'OK' thing.

[collin924]

Hi  atcodedog05 ,

Thanks for you response but it's not what I mean.

I don't want to separate the 'OK' and 'NOK'.

I want to check all cells in 'status' and if there contains any 'NOK', the workflow will not give out any data neither the 'OK' thing.

[atcodedog05]

Hi @collin924 

Ok got it

Here is a workflow with 2 scenarios 

I have a column which is doing a overall check.

If even one of the status is NOK True will be Empty if not all will be True. And you can attach Email tool to True.

Hope this helps 🙂

[atcodedog05]

Hi @collin924 

Please do check and let me know.

[collin924]

Hi atcodedog5,

Thank you! Because of the time difference I saw it just now.

I tried your method, but a little more question:

When all is 'NOK', the workflow will still send out the email with blank content.

Is there any way to solve this problem?

thanks

[atcodedog05 · Accepted solution]

Hi @collin924 

Here is a workflow for the task. The workflow throws and error and stops the execution if its NOK

Workflow:

On run:

It throws an error.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[collin924]

Hi,

Thanks a lot! I've got you method.

regards,

Collin