Check condition and determined what to do next

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,

Reporting

Accepted answers

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 😀👍

All comments

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%2C%20maps%2C%20and%20tables.

and here,

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

Hope this helps.

Thanks

Philip

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.

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.

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 🙂

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

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 😀👍

Hi,

Thanks a lot! I've got you method.

regards,

Collin

Quick Links

Tags

This months top contributors

AkimasaKajitani 382

Hollingsworth 335