How do I send out blank email on alteryx

[ericren]

Hi,

Please see the image below for reference. 

I am getting cases where the Left output of the join tool is blank. I want to send out an email regardless if it is blank attaching the text part to it.

It does not send the email as the text part is linked to the table. There is no table if it is blank. 

How do I work around this?

[DanM]

one suggestion would be to use the Record Count tool after the left Join. Then append that record count back to the data in the left join. After appending use a formula tool and do an If statement that says something like, "if Record Count = 0 then ' ' else data field endif".

What that will do is trick the table tool into thinking there is data when all there is is a space. It should still create the table although just with a space and still send the email.

If you don't want the table if there's no data, you can add a filter tool and do a record count is equal to zero and push to the text tool. I think the text tool can take more than one input so it shouldn't mess anything existing up. Sorry don't have Alteryx open so this is off the top of my head.

[ericren]

Hi,

Can you send me an example?

[JagdeeshN]

Hi @ericren ,

The solution that @DanM has mentioned will work perfectly for your use case. Please refer to the screenshot below to get an idea about how to implement it.

Best,

Jagdeesh

[ericren]

I am not able to point the email body to the table. The only option is the count.

I want to send an email out with a text body and if there is any Left from Join, append to the body.

[JagdeeshN · Accepted solution]

Hi @ericren ,

You will have to use a combo of filter and union tool to append the table and not the count. Count is only for checking purposes.

Please find attached a sample that showcases this. Hope this helps you get forward in your solution.

Best,

Jagdeesh