Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sending different email based on cell value

ericren
8 - Asteroid

Hi everyone,

 

I have a case where I am inputing one of the two data set below. 

 

valuetype
0.4a
0.3b
0.49c

 

valuetype
0.4a
0.3b
0.49c
0.51d

 

I would like to send a different email based on the value column.

Only 1 email should be sent depending on the 2 cases. 

 

If there is no value cell greater than .5 send this:

No value above .5. Thank you

 

 

 

If there is a value cell greater than .5 then send this:

There is a value greater than .5. Please see below. 

 

valuetype
0.51d

 

 

 

3 REPLIES 3
binuacs
21 - Polaris

@ericren Can you explain how the two data sets are related? 

ericren
8 - Asteroid

Sorry for any confusion.

 

I have updated the original post. 

 

I have a case where I am inputing one of the two data set below. 

 

binuacs
21 - Polaris

@ericren One option is to check the count of the records which is > 0.5 and send emails. Attaching a sample workflow 

 

Note: please configure the email tool

 

binuacs_0-1673560511826.png

 

Labels
Top Solution Authors