You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » How to send an Email in only once towards several addresses
#1 2009-06-12 17:11:08
- DjeCepap
- Member
- Registered: 2008-01-28
- Posts: 24
How to send an Email in only once towards several addresses
Hi;
I created a Job which enables me to generate Excel files from delimited files (1 delimited file generate 1 Excel file).
(tFileList ==> tFileInputDelimited ==> tFileOutputExcel)
The name of each file is composed of a code recipient and a date, for example (VENDOR1_20080612.XLS).
With the segment recipient (VENDOR1) codes are attached several E-mail addresses in an Oracle table. For example
VENDOR1 | Adr_1
VENDOR1 | Adr_2
VENDOR1 | Adr_3
VENDOR2 | Adr_A
VENDOR3 | Adr_25
VENDOR3 | Adr_32
How then I to make with Talend to send the file Excel in only once at all the associated addresses?
For example file VENDOR1_200080612.XLS must be sent to Adr_1; Adr_2; Adr_3.
Thank you for your assistance
(I Use Talend 3)
Offline
#2 2009-06-12 18:05:11
Re: How to send an Email in only once towards several addresses
Hi,
You can find the solution into the following screenshot.
3 step to achieve it :
1/ using a tDenormalize component and specify which column is denorlized => Email
2/ then use a tFlowToIterate to send an email per Vendor
3/ finally put into the TO field the following value : sortie.Email => it means the list of your vendor's emails (like addr1 ; addr2; addr3)
Best regards;
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » How to send an Email in only once towards several addresses