[resolved] Output to tSendmail in Message

[Anonymous]

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

[Anonymous · Accepted solution]

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/10... to see if it is useful for your use case.
Best regards
Sabrina

[Anonymous]

Many thanks that was just what I wanted.

[Anonymous]

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

[Anonymous]

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