Attaching multiple files based on conditions

Question

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

DocumentName 1DescriptionEmailTest 1XYZ companyError 1John@xyz.com;Jane@xyz.com;jane@xyz.comTest 2XYZ companyError 1John@xyz.com;Jane@xyz.com;jane@xyz.comTest 3XYZ companyError 2John@xyz.com;Jane@xyz.com;jane@xyz.comTest 4XYZ companyError 2John@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 · Answer

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-using-semi-colon/idi-p/134714

rdeshpande · Answer

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

flying008 · Answer

Hi, @rdeshpande

Try this,