I am trying to do Email Bursting
I have Multiple files in Folder (Tfilelist)
I have email ids in Excel
I am able to send multiple emails to multiple users,but system is sending same attachment to all the users
Excel has file name,email id
i want to pick email id from excel and add attachment related to that email 'id
Have you got differents status for each line (for one sheet) ?
Or each excel file has one status : approved - unapproved
So for each sheet or for each line (depend on), you have to catch the value of 'time status' & send a mail.
For this you I will use a tFlowToIterate (that put flow value in globalMap) and after that link with trigger conditionner 'run if'.
if TimeValue equals approved => send mail 1
otherwise => send mail 2
Actually i have file names and email in excel,using Tflowiterate i am pulling email as global variable in "TO" address as ((String)globalMap.get("row7.EMAIL"))
Folder contains file names-->using file path i have defined global variable in attachments as ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
But system is sending emails to mutliple users but picking same attachment for everyone
System should pick each file as attachment and take email id for that particular file name from excel and send emails
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables