Dear sanvaibhav, I have a job requirement in which i have to take email ids from the excel sheet and send the email notification to that email ids. excel sheet is containing list of email ids. Regards, Csah
Hi, tfileInputExcel-->tjavarow-->titeratetoflow-->tpop Read your column containing excel file Create context variable email_id Assign value of incoming row to context variable in tjavarow use context variable in tpop for mail Id Try using similar logic/concept. Vaibhav
Hi, Following is example itself - tfileInputExcel-->tjavarow-->titeratetoflow-->tpop Read your column containing excel file Create context variable email_id Assign value of incoming row to context variable in tjavarow use context variable in tpop for mail Id Try implementing it and whatever problem you face, pl let us know. Try implementing solution from following example. You will understand the basic of how to use iterate... https://help.talend.com/search/all?query=tIterateToFlow&content-lang=en This will help you Vaibhav
Whatever you get on console you can redirect it to the job, but need to do some small java coding...
pl check the blog -
http://helicaltech.com/redirecting-talend-console-logs/ Code is simple
java.io.File logFile = new java.io.File(?_logs/?+projectName+?.log?);
java.io.PrintStream ps = new java.io.PrintStream(new java.io.FileOutputStream(logFile));
System.setOut(ps);
System.setErr(ps)
This writes logs as well as info from console to file.
Thanks
Vaibhav
