Attaching multiple files based on conditions

[rdeshpande]

Hello community,

First of all, this community is immensely helpful in my Alteryx progression, so thank you all!!!

I need to send email based on conditions in the table below

Document	Name 1	Description	Email
Test 1	XYZ company	Error 1	John@xyz.com;Jane@xyz.com;jane@xyz.com
Test 2	XYZ company	Error 1	John@xyz.com;Jane@xyz.com;jane@xyz.com
Test 3	XYZ company	Error 2	John@xyz.com;Jane@xyz.com;jane@xyz.com
Test 4	XYZ company	Error 2	John@xyz.com;Jane@xyz.com;jane@xyz.com

If the Name 1, Description and Email is the same then all the files in the Document column should be attached to that email.

In the sample table above

Email 1 - Send to John@xyz.com;Jane@xyz.com;jane@xyz.com with Subject Error 1, attachment Test 1 and Test 2

Email 2 - Send to John@xyz.com;Jane@xyz.com;jane@xyz.com with Subject Error 2, attachment Test 3 and Test 4

The table can have various number of lines. Any help is sincerely appreciated. Thank you again

[flying008]

Hi, @rdeshpande 

Try this, 

[rdeshpande]

Thanks much for your help. Unfortunately, concatenation of  attachments separated by comma unfortunately did not work

[flying008]

Hi, @rdeshpande 

Try use semicolon ; to split attach file path. If can't get your want, then use text to column tool to split the [Attach] field by comma.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Email-Tool-Multiple-attachments-usin...