How to trigger tSendEmail notifications on errors based on certain criteria

[Anonymous]

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

[TRF]

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?

[Anonymous]

Appreciate if couple of solutions are provided.
Thanks
SK

[TRF]

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.

[Anonymous]

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