tsendmail send same mail manytimes

[Anonymous]

I'm trying to join two tables and send the result of the join filtered in a tsendmail, Job below :

What I want to do is to send the rows collected in the same mail

My problems is that it's sending the same row many times.

Can you help solving this problem ?

[vapukov]

---

@SwanGhazi wrote:

@vapukov  I should create that file before tjavaRow right ?

---

"
- Doctor, could you recommend for me a best medication to prevent a baby?
- glass of water
- wow!!! should I use it before sex or after?
- instead of!
"

🙂

btw, I don't know - what are you doing in tJavaRow, but tFileOutputDelimited - must be the last in subjob, it and create the file and populate it with data

1 st subjob (group of components in Talend terms) - preparing data and store it in file or variable (if not too big)

2nd subjob - send it

3rd - cleanup (delete file)

[Anonymous]

@vapukov  I've mentioned in a previous comment that I'm using TjavaRow to embed the output of the tmap in an HTML code and put the result in a global variable that I call in my tsendmail 

[vapukov]

it is simple, it is just separate and independent processes:

• prepare csv file, nothing about HTML - read from DB all what must be sent, save it to file
• send eMail, here - prepare text (in your case tJava)
• cleanup - delete csv file after sending

cheers

[Anonymous]

@vapukov  can you assist me here to use the tFileOutputDelimited to put the date in my tjava ? 

[vapukov · Accepted solution]

you can not use file in tJava (only file name)

in tJava you can use prepared variable (globalMap)

prepare file nd variables:

send email with prepared text and attachments:

[Anonymous]

@vapukov  I've just understood what you meant by the file  

 I'm so sorry took a lot of time to get you! I'm just having a problem that the mail is sent many time how can i prevent that ?