topic Re: Clear Table in mail body every iterate in Talend Studio

Clear Table in mail body every iterate

Anonymous — Sat, 16 Nov 2024 02:37:42 GMT

Hi experts,

My objective is to insert a data-table in email body and send to every recipient

but the problem is the data-table merged in every iterate.

How I can clear the data in TJAVAROW in every iterate to avoid merging of rows

here is the diagram of job:

tJavaRow code

tsendmail

Current output and Expected Output in email body

Re: Clear Table in mail body every iterate

TRF — Tue, 21 Apr 2020 14:52:14 GMT

Add a tJava component after tSendMail connnected by OnComponentOk and use the following code:
globalMap.put("mailMessage", "");
You may also use a tSetGlobalVar instead.

Re: Clear Table in mail body every iterate

Anonymous — Tue, 21 Apr 2020 23:15:21 GMT

Sir @TRF ,

it works on the data,

but the html formatting disappear on 2nd iterate.

output:

1st email

EMPLOYEE_NO	EMPLOYEE_NAME
12345	DELA CRUZ, JUAN

2nd email

93832BONIFACIO, ANDRESS

Re: Clear Table in mail body every iterate

Anonymous — Wed, 22 Apr 2020 02:15:41 GMT

Got IT

by moving the

"<TABLE border=1 cellspacing=1px>" + "<TR><TD>EMPLOYEE_NO</TD><TD>EMPLOYEE_NAME</TD></TR>"

in the body of email

Thanks a lot Bro!