You are not logged in.
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)
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)