Hi sam, Following code would generate the yesterdays date... in tMap filter, you will have to compare the date column with this which will filter out the dates which are not required. You can also think of using tFilter component after tMap and use following expression inside the value... TalendDate.formatDate("yyyyMMdd", TalendDate.addDate(TalendDate.getCurrentDate(), -1, "dd")) thanks vaibhav
hello Vaibhav, Thanks for Suggestion. Now,My another question is that what i do if i want to fetch records from employee and adress table both are connected by Address_id but the only that records stored which has city from pune Thanks.
I haven't worked on the scenario, but I can tell you how it is possible. Get the data from salesforce using SFInput component. Use tMap to extract only emailIDs from input data and write it to file. Use that file as input and use iterate concept and connect it to tSendMail component to send mail to each mailID. Hope this is what you are looking for. Thanks Vaibhav
hi vaibhav, when we import any csv file on salesforce that time salesforce imediatly send mail on our mail id. so, My question is that, can we also perform this operation using talend and how? Is there any special tool given for these operation? please reply me with every discription with screen shots. Thanks, Sam