In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Conditional E-mail Tool

iamRandy
8 - Asteroid

Hi, I created a workflow with email tool options

 

1) Send e-mail IF there are records. I'm doing an email attachment.

2) Send e-mail IF there are NO records. I have a custom body email

 

if [Count]=0 then "There are no data available from reporting week of " + [Week Start] + ". "  else Null() endif

 

 

The issue i am having is that the workflow executes both #1 and #2 emails options are sent out.

The task is to send email based on the 2 options above.  For example, If on 3/1 there are 3 records, Option1 email should be sent out and not send Option 2; vice versa, if on 3/2 there are 0 records, Option 2 email should be sent out and not send Option 1.

 

Please advise. thanks in advance.

 

email_tool.png

10 REPLIES 10
jrlindem
12 - Quasar

@karenss6  I see you are using Containers, but CONTROL containers are different.  More like this:

jrlindem_0-1758917696639.png

You see how the filter tool is connecting directly to the control container?  This is how you can accomplish conditional behavior.  -Jay

Labels
Top Solution Authors