Sending single email by formatting the table..

[hayley93]

Hi, 

I managed to make a table like below in Alteryx and need to send an email for the very last step.

Ref No.	Department	Status	Count
000001	HR	Approved	5
000001	HR	Rejected	2
000002	Marketing	Approved	3

But,if I send an email like the above, HR will get twice for the approved and rejected.

I want to work on in this way that HR can get one email including the ref no. , count and two different types of status. 

Does anyone know how to group the same Ref No. & Department, but still show different status types & count? 

Please help!!

Thank you in advance. 

[JosephSerpis]

Hi @hayley93 I mocked up a workflow let me know what you think?

[hayley93]

Hi Joseph! 

Thanks for your reply.

Could you please help if it can be grouped by the same Ref Number & department?

I want to send single email for the same Ref No. & department, but includes different count & status type....

Hope it makes sense! 

[JosephSerpis · Accepted solution]

Hi @hayley93 I edited my workflow with two methods on how I would approach this. In the attached example you will need to fill out the details for your SMTP and email recipients. Let me know if you have more questions.

[hayley93]

It worked! Thanks for your help!