Alteryx Designer Desktop Discussions

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

Email Function

grail0305
6 - Meteoroid

Hello Everyone, Just want to ask if it is possible to create a workflow that will send two types of email but only will be sent base on the the data ? for example, If there is a data or content on the output an email will be sent and if there are no data  another version of email will be sent, but take note that I will be only sending one email only after it runs based on the content, I tries to used the filer tool but still both email at the end are being sent.

 

Thank you so much in advance 

8 REPLIES 8
binuacs
21 - Polaris

@grail0305 use the count record tool and based on the count you can setup the email, sample workflow attached

image.png

OTrieger
13 - Pulsar

@grail0305 

Another option is simply put a filter tool, checking IsEmpty() which is very similar to the above solution only without the Count and pending tools.

grail0305
6 - Meteoroid
@OTrieger Do you have Examples?

 

grail0305
6 - Meteoroid

@binuacs Does this workflow will only send only 1 email ? it will ignore the other and not run it? That is based on record count?

binuacs
21 - Polaris

@grail0305 yes , it will send only one email based on the count

grail0305
6 - Meteoroid

Thank you , I just want to give a clear scenario to my problem given the data below:

ID_NOName
123Mark
456Bryan
789Roger

 

Since there is a data in the excel File having 3 students and email will be sent stating that there is a student logged, hence,

If the data is like given in the example below:

ID_NOName
  
  
  

 

In times when the alteryx run and there is no data at all another email version will be sent stating there are no student in the input file.

 

only one email will be sent base on the content of the input tool.

 

binuacs
21 - Polaris

@grail0305 This should work with the sample workflow I provided

grail0305
6 - Meteoroid

I tried it already but it seams it always goes to the lower email? can you help provide a specific instruction?

 

Labels
Top Solution Authors