Need Help On designer desktop

Question

Hi All, 
I have a data like below. For which i need to send email to example@gmail.com

This data will be my input file

Column A Column B  Column C
SAm          001             CALL

PRITI        002              TXT

Hazel         003             EMAIL

I need to derive the subject line based on Column C

And send 3 separate email email to example@gmail.com

The body should include the data

EMail 1 Subject Call
Column A Column B  Column C
SAm          001             CALL

Email2 Subject txt

Column A Column B  Column C

PRITI        002              TXT

Email3 - Subject EMail

Column A Column B  Column C
Hazel         003             EMAIL

Can some please help.

Dhrish · Answer

@Sameer_Kanade8810 For your requirement you can just modify @alexnajm workflow with adding a group by with Column A in the Table Tool.

binu_acs · Answer

@Sameer_Kanade8810 @What@alexnajm suggested was the dynamic way of doing it, do you face any issues implementing that approach?

Sameer_Kanade8810 · Answer

Hi @Hsandness

What this works when i have a single user.

Lets say i have

Columna A COlumn B COlumn C

Hazel        002             Call
Ronlad      002             Call

I need to send two separate email

Email 1 Subject Call

Columna A COlumn B COlumn C
Hazel        002             Call

Email 2 Subject Call

Columna A COlumn B COlumn C
Ronlad      002             Call

Can this be done.