topic Re: [resolved] Output to tSendmail in Message in Talend Studio

[resolved] Output to tSendmail in Message

Anonymous — Thu, 26 Jun 2014 17:32:24 GMT

I'm looking to output the results of a process within the main message text body of the email (not as an attachment).
I have a small table in PostgresSQL that has two columns - Date and Number and wish to list the output of this table into the message. The table contents will be dynamic but should not go beyond 4 or so rows.
Is there a method I can use to produce the results I want. I'm using v5.4.1 of TOS

Re: [resolved] Output to tSendmail in Message

Anonymous — Fri, 27 Jun 2014 03:54:45 GMT

Hi,
Could you please take a look at related forum https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/td-p/100984 to see if it is useful for your use case.
Best regards
Sabrina

Re: [resolved] Output to tSendmail in Message

Anonymous — Fri, 27 Jun 2014 10:17:58 GMT

Many thanks that was just what I wanted.

Re: [resolved] Output to tSendmail in Message

Anonymous — Fri, 27 Jun 2014 10:26:41 GMT

Hi kalypso,
Thanks for your quick response. Let us know if there is any further help we can give.
Best regards
Sabrina

Re: [resolved] Output to tSendmail in Message

Anonymous — Fri, 27 Jun 2014 11:02:46 GMT

hi all,
I think that tFlowToIterate is more appropriated as it automaticly create global variable in globalMap that could be used in tSendMail.
You could retrieve each key name in code viewer normaly - doesn't work each time - never mind it's the useful talend way "row.column.
https://help.talend.com/search/all?query=tFlowToIterate&content-lang=en
regards
laurent