topic Dynamic HTML Table in tSendMail in Talend Studio

Dynamic HTML Table in tSendMail

thiagoft — Thu, 30 Apr 2020 21:03:36 GMT

Hi I'm trying to create a table in the message of tSendMail that would send the data to that specific email/list of emails from an excel file.

Each email/list of emails would receive only the records that match that email.

So far I can send the email but I have it for each record, one email and that would create hundreds of emails and some people would get multiple emails, we are just trying to combine the data for that specific email into one message.

Thank you

The data in the excel file would look like this

email | id | make | model | comment

email1 | 1 | a | XX | abcdef

email2 | 2 | a | YY | abcdef

email2 | 3 | a | XX | abcdef

email1 | 4 | a | ZZ | abcdef

email3 | 5 | a | XX | abcdef

The email would be:

to email1:

id | make | model | comment

1 | a | XX | abcdef

4 | a | ZZ | abcdef

to email2:

id | make | model | comment

2 | a | YY | abcdef

3 | a | XX | abcdef

to email3:

id | make | model | comment

5 | a | XX | abcdef

Re: Dynamic HTML Table in tSendMail

TRF — Thu, 30 Apr 2020 22:25:23 GMT

tfileInputExcel-->tUniqRow-->tFlowToIterate-->tfileInputExcel(filter expression on input flow to get only records matching with "rown.id" created by tFlowToIterate)-->tJavaFlex(to build the message body within a global var)
Add a 2nd iterate flow after tFlowToIterate to send 1 email per id using tSendMail
Should work (or not so far)

Re: Dynamic HTML Table in tSendMail

thiagoft — Tue, 05 May 2020 14:41:33 GMT

Thanks @TRF , I'm learning here still, but not sure how to "filter" the second tfileinputExcel.