Merge multiple email layouts into single email

vepp

Hello All,

I have a sqllite file with multiple layouts. Currently I have 5 layouts and every time I run it, I get 5 individual email alerts per layout. I would like to combine 5 or more layouts into 1 single email. How to achieve this? Please guide me as I am new to Alteryx.

Input:

Current Output :

Like Below I am getting 5 similar emails for each row

Data Process Report
27-May-19
Files Processed	Processed	Count
Row1 Layout email	Yes	984

Expected Output :

Data Process Report
27-May-19
Files Processed	Processed	Count
Row1 Layout email	Yes	984
Row2 Layout email	Yes	120
Row3 Layout email	Yes	200
Row4 Layout email	Yes	100
Row5 Layout email	Yes	250

Regards,

Vp

danilang

Hi @vepp 

You can use something like this to group your records into a table and use the table as the body of the email

resulting in 

Note that the email tool in the attached workflow doesn't have the SMTP:, from: or to: defined for confidentiality reasons.

Dan

MergeEmail.yxmd