Clear Table in mail body every iterate

[Anonymous]

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

[TRF · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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!