topic Re: How to trigger tSendEmail notifications on errors based on certain criteria in Talend Studio

How to trigger tSendEmail notifications on errors based on certain criteria

Anonymous — Fri, 21 Sep 2018 21:20:17 GMT

Hi There,
I'm currently working on a project. And the criteria is checking if the failure is on a list of cities then trigger an email to an individual. If city A then trigger email to abc@abc.com.
If city B then trigger email to def@def.com and so on. How do i design this from my SQL input in TOS. tSqlInput > tMap> tLogRow>tSendEmail>>>
Appreciate your help.
Thanks & Regards,
Suresh

Re: How to trigger tSendEmail notifications on errors based on certain criteria

TRF — Fri, 21 Sep 2018 22:44:02 GMT

There are 10s of solutions.
How can we give you the best one with no information regarding how the city and the indivual are represented?

Re: How to trigger tSendEmail notifications on errors based on certain criteria

Anonymous — Sat, 22 Sep 2018 05:18:08 GMT

Appreciate if couple of solutions are provided.
Thanks
SK

Re: How to trigger tSendEmail notifications on errors based on certain criteria

TRF — Sat, 22 Sep 2018 06:37:38 GMT

How can you join city and email address?
Are they both stored in the same table?
In this case it's easy to get the email with the city.
Are they stores in separated table?
In this case you need to join both tables in your SQL query or using a tMap.
Do you have to hardcode email address?
Never a good practice but in such a case you can use tFixedFlowInput to represent informations as a table or, much more better, store the couples "City,Email" into a CSV file.

Re: How to trigger tSendEmail notifications on errors based on certain criteria

Anonymous — Sat, 22 Sep 2018 13:08:55 GMT

Thanks a ton. I understand what you are saying. Maybe I'll try and if need will take your advice.
Thanks again..