One Input to multiple output function

[joe86]

i have a data set as below (only dummy):

Country; Person; Email

India; abc; 123@gmail.com

India; def; 456@gmail.com

India; xyz; 356@gmail.com

USA; hjg; 876@gmail.com

USA; jki; 986@gmail.com

Canada; oiu; 354@gmail.com

Canada; uyr; 876@gmailcom

the above data set is a result set of my logic. i need to send a mail as below:

1. All persons listed in India should get one mail and that mail body/atachment should not have other country details.

2. All persons listed in USA should get one mail and that mail body/atachment should not have other country details.

Similar for Canada also.

In my actual result set, there will be around 50 countries. I do not prefer writing 50 outputs using tMap. Rather would like to implement some looping kind of stuff. Not sure how to build that. Can someone please help?

Can someone please help on how to being this.

[Anonymous]

Did this solve your issue?

[joe86]

i replied to you yesterday with a query. Not sure, why was it not displayed here. Anyways, just modified a bit of ur valiable (from the link provided) and it worked. But still, there was an issue. I wanted to send mail one by one - Customer from India will get one mail, Customer from USA will get one mail, Customer from Canada will get one mail. And these mails will not have details of other countries. For that I was stuck in iterate process. And at last it woked out
Thanks for ur support and patience