insert table in email

[Anonymous]

I want to send email though talend in which i want to insert a table. This table comes from data processing activity in which i join two mySQL tables and sort the data based on a column. How can i send this result in email body with a fixed salutation and signature?

I have read https://community.talend.com/t5/Design-and-Development/resolved-need-to-send-the-data-of-tLogRow-to-...

and 

https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/td-p/10...

however these examples are for sending results directly from DB without any processing. Below is what i have done so far.

[TRF]

Hi,
Regarding your job, tSendMail is not connected with any other component, so it will start at the same time as tMysqlInput and for sure, will not give you the expected result.
So, connect these 2 components using trigger onSubjobOk.
Now, I suppose the result is built in tJavaRow using global variables.
So you just have to reuse these variables in tSendMail to get the expected message, perhaps using html for a friendly presentation.
If you have some difficult to get what you want, share details for each component configuration.

[Anonymous]

The only problem i am facing is that i can't see onSubJobOk option, rest i understand how to do. 

[TRF]

You need to connect the 1st component with onSubJobOk, you cannot connect an other one.

[Anonymous]

Where exactly is first component? tMysqlinput1, tMysqlinput2, tMap1, tSortrow1, tJavarow or tSendemail? I assume that you're talking about tSortrow1 and tJavarow. And again which component should be connected with which component as onsubjob1? and what connection type for second one?

[TRF]

The 1st one is the green one, tMysqlInput in your case.

[Anonymous]

Now i can't connect between tMySqlInput1 and tMap1 through subjob. I even tried with tJoin and its not working either.

[TRF]

Of course you cannot!

You just have to connect tMysqlInput_1 to tSendMail_1 using onSubjobOk to be sure tSendMail_1 will start after the variables you use to construct the email will be populated.

Also rearrange the job design, move tMysqlInput_2 on top of tMap_1, then move tSendMail_1 to the left (where is actually tMysqlInput_2).

[Anonymous]

Can you post a screenshot or flow chart?

---

@TRF wrote:

Of course you cannot!

You just have to connect tMysqlInput_1 to tSendMail_1 using onSubjobOk to be sure tSendMail_1 will start after the variables you use to construct the email will be populated.

Also rearrange the job design, move tMysqlInput_2 on top of tMap_1, then move tSendMail_1 to the left (where is actually tMysqlInput_2).

---

post a screenshot? or flow design?

[TRF]

should look like this:

Sorry for the quick and dirty design!