问题描述
我正在使用软件 talend 处理Enterprise应用程序体系结构的项目我有此表:用户(ID用户，名称用户，电子邮件)我想做的是从此表中选择数据"，然后使用Tsendemail组件向每个用户发送电子邮件
到目前为止，我可以使用 TMssinput 与数据库建立连接，并使用Tsendemail发送单个电子邮件
但我不知道如何选择Row的值并将其用作 Tsendemail 的电子邮件"
有人可以帮我吗?谢谢你
I m working of a project of Enterprise application architecture using software talendi have this table : User(Id_user, name_user, Email)what i want to do is select Data from this table and sending email to each user using Tsendemail component
i could so far make a connection to Database using TMssinput and send a single email using Tsendemail
but i dont know how to select values of Row and use them as "email" for Tsendemail
Can someone help me pls ? and thank you
推荐答案
由于tSendMail组件不是处理组件(即，它不能处理输入中的多个向量)，而是起始组件，所以最好的方法是像我们一样使用良好的tFlowToIterate 在这里.您的工作几乎像这样:
As tSendMail component is not a processing component (ie, it cannot handles more than one vector in input) but a starting component, the best way to do so is to use the good-ol' tFlowToIterate as we did here. Your job will almost look like:
tMssInput---row---->tFlowtoIterate--->Iterate---->tSendEmail
在tFlowToIterate实例内部，您将需要的所有内容从row放入globalMap.在此之前，应在row上下文中完成所有数据处理操作(例如，筛选出您不会发送邮件的用户，等等).
Inside the tFlowToIterate instance you're going to put everything you need from row into the globalMap. Every data-processing operation should be done before that, on the row context (for example, filtering out users you won't the mail to be sent, etc.).
这篇关于发送多封电子邮件，其中包含Talend Open Studio中行中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！