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 ?
Solved! Go to Solution.
the simplest way - store all in csv file and run tsendmail as separate subjob connected by OnSubjobOk trigger with attachments
You can use tjavaflex just before tSendmail and save you rows from table in array and then using global variable you can print in under "Message box" in tSendmail component.
@rahuljan I'm using TjavaRow to read the output that I'm injecting in an HTML Code and then using the global variable to send the email.
Can I declare the array in the same place and using it afterward or I need to move the code to the tjavaflex
@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)
@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
it is simple, it is just separate and independent processes:
@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 ?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach