[resolved] need to send the data of tLogRow to tSendMail.

[Anonymous]

Hi Team,
I have a job which reads the data from *.CSV and details are as follows,
tFileList  --> tFileInputDelemiter --> tmap --> tLogRow -->tSendMail
Here tfileList reads all CSV files and gives the data to tLogRow.
Here I am able to print tLogRow in console, but I want the data which is available in tLogRow to be sent as an email, How to do that?
Note: .CSV files are of same types

[Jcs19]

just put tJava after tMap lol

[Anonymous]

hmmm .. tJava do not manage flow. I guess you've only got null value !

[Jcs19]

Yea but you write the result into a context variable as  xdsho tol d

tJava to write into a context variable (you dont need <tr> and <td>)

tSendMail using the context variable

Output email : 

[Anonymous]

you're right  & efficient presentation of data in tsendMail but RajendraLella seems to catch the data from flow not the logs.
on the other hand, but it's a very personel feeling, I don't like to use context to store value that don't change due to differents environment .. prefer the globalMap ... but it's just a point of view & I know a lot use context to re-use data later

[Jcs19]

for the data flow  you can use row1.name like you did on your screenshoot (it works)!
(but use tJavarow not tJava)

stop me if i'm wrong, i'm noob 

[Anonymous]

Hi,
 Please take a look at a KB article about: TalendHelpCenter:What is the difference between tJava, tJavaRow and tJavaFlex?
Best regards
Sabrina

[Anonymous]

Hi,
I am using the below flow for sending a single mail to the recipient about all the information in the tfileoutputdelimited.
tfileoutputdelimited contains no of rows of information which has to be sent as an email.
tfileList-->tfileinputdelimited-->tfileoutputdelimited-->tjavarow-->tsendmail
At the end of this job, i was able to put information in the email, but it sends several emails.
My file generated by tFileOutputDelimited in the above job contains all the information i need to put in the final mail.
Can you help me in this.
Thanks,
Rajendra

[Anonymous]

Hi Rajendra,
Could you please show us your job design screenshot?Did you use "Iterate" or "OnSubJobOk" between tjavarow and tsendmail?
Best regards
Sabrina

[Anonymous]

Hi,
I am not able to connect using "OnSubjobOk" ot iterate.
PFA the screenshot                                                 

[Anonymous]

Hi,

I am not able to connect using "OnSubjobOk" ot iterate.

That's the reason why you got several emails.
Please take a look a related forum: https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/td-p/10...
Best regards
Sabrina