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