topic Adding Table format in the SendMail Component in Talend Studio

Adding Table format in the SendMail Component

Anonymous — Wed, 26 Aug 2015 06:55:57 GMT

How i can add a proper table format to display the content in SendMail. Below is my Job

Now the java flex has
         Start Code:
             String result_set="";
Main Code
result_set=result_set+" "+" "+" "+email_output.Name+" "+" "+" "+email_output.EmpID+"<p>";

End Code
      globalMap.put("result",result_set);

SendMail message has

(String)globalMap.get("result")

-Advance setting: MIME type ='HTML'

I get output like below

eg:

--------------------------------------------------------------- Output -------------------------------------

Name Number

Jhon   EMP00123
Daniel    EMP111111

-------------------------------------------------------------------------------------------------------------

This works, But you can see the column are not properly indent.

So how i can achieve the proper indent ?
Any help is greatly appreciated

My job desgin

Re: Adding Table format in the SendMail Component

Anonymous — Wed, 26 Aug 2015 08:34:22 GMT

hi Ikv,
Why are you using tjavaflex for that ?
branch your flow directly to tSendmail or use flowToIterate (that put each field in globalMap)

regards
laurent

Re: Adding Table format in the SendMail Component

Anonymous — Wed, 09 Sep 2015 23:30:59 GMT

I got this by adding below code in Java Flex
Start code

String result_set="<style>table, td {    border: 1px solid black;    border-collapse: collapse;}table, th { border: 2px solid black;}th, td {padding: 3px;},th {text-align: left;},th {background-color: DodgerBlue; color: white;},td{font-family: arial; font-size: 10pt;}</style> <table style=width:100%><tr><th>Name</th><th>Number</th> </tr>" ;

End Code
          result_set=result_set+"</table>";
      globalMap.put("result",result_set);