[resolved] Output to tSendmail in Message

One Star

[resolved] Output to tSendmail in Message

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

Accepted Solutions
Moderator

Re: [resolved] Output to tSendmail in Message

Hi,
Could you please take a look at related forum http://www.talendforge.org/forum/viewtopic.php?id=36026 to see if it is useful for your use case.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: [resolved] Output to tSendmail in Message

Hi,
Could you please take a look at related forum http://www.talendforge.org/forum/viewtopic.php?id=36026 to see if it is useful for your use case.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Output to tSendmail in Message

Many thanks that was just what I wanted.
Moderator

Re: [resolved] Output to tSendmail in Message

Hi kalypso,
Thanks for your quick response. Let us know if there is any further help we can give.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: [resolved] Output to tSendmail in Message

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