Sending single email by formatting the table..

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.

Gallery

Accepted answers

JosephSerpis

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.

Combine_Columns_07052020.yxmd

All comments

JosephSerpis

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

Combine_Columns_07052020.yxmd

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

Combine_Columns_07052020.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703