how to find global variable name or var having value of iterate ??

[aminegac]

hi i am new to talend open studio , i am extracting data from an excel file having list of emails , i already have the emails but i cannot find a way to pass the emails one by one to tSendEmail compnent , my goal is to send emails to different adresses each one alone one by one .

you can see details in the picture below .

any other solution to do find the correct name in my process , or any way to iterate throught the file by another way where i can specify the valid name of temporary variable having current email to tSendEmail componenet??

[Anonymous]

Hi

I see you are using tFlowToIterate component to iterate the input flow, if one of column is the email address, you can access the current email address in the TO field of tSendMail with this expression:

(String)globalMap.get("row10.TheColumnName")

Regards

Shong

[aminegac]

thank you @shong i will try doing that trick and tell if it worked .