Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Conditional Email with attachments

Highlighted
7 - Meteor

Hey guys,

 

I am stuck and seeing if you guys have an example and solution on how to do this.

 

The scenario is:

- I have a data with Filter (True or False) and it then saves down records for each case as excel output dynamically as filename. DDMMYY 

- I will always have records on True case but might not have records on False case thus Alteryx will only save output when there are records.

 

What I would like to do is send out 1 email with the attachment, so if False case has no records will send out email with 1 attachment and if False case has records will send out 2 attachment.

In the email tool I have the two attachment listed but the workflow fails when on the False case does not generate an excel output......

 

Does anyone know how to do go about this and if they have a sample workflow that would be great?

Also is there a way to always save down the output even though there is no record. This could be a solution.

 

Thanks,

Jax

 

 

Highlighted
9 - Comet

Hi @Jax23

One thing you could do is have 2 separate email tools. One configured for 1 attachment, and another for both.

 

You can have a check for whether false case has records or not. Based on this check, only one of the email tools will be triggered (either through enabling/disabling containers or by using the detour tool) 

 

Cheers,

B

Highlighted
7 - Meteor

Thanks that worked.

Labels