topic Re: [resolved] transformations in Talend Studio

[resolved] transformations

Anonymous — Tue, 19 Aug 2014 09:37:56 GMT

hi everybody,
i want to filter only those record which was stored yesteday can someone please tell me How can i fetch that records using Created date field?
thank you,
Regards ,
Sam

Re: [resolved] transformations

Anonymous — Tue, 19 Aug 2014 10:55:37 GMT

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

Re: [resolved] transformations

Anonymous — Wed, 20 Aug 2014 12:36:05 GMT

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.

Re: [resolved] transformations

Anonymous — Wed, 20 Aug 2014 12:41:39 GMT

Use tFilterRow next to tmap and use appropriate filter to filter the record with respect to specific column.
https://help.talend.com/search/all?query=tFilterRow&content-lang=en
thanks
vaibhav

Re: [resolved] transformations

Anonymous — Thu, 21 Aug 2014 09:03:09 GMT

Hi everybody,
i have a problem while fetching Data of Sales-force from three entities i.e Opportunity,Quote and QuoteLine_id.
Somebody give me Suggestion.

Re: [resolved] transformations

Anonymous — Mon, 25 Aug 2014 10:05:40 GMT

hi vaibhav,
i have one table i.e
name City
Sam Pune
Deoo Nagpur
john Pune
from this table how can i fetch the record whose city=Pune in Tmap
Thanks.

Re: [resolved] transformations

Anonymous — Mon, 25 Aug 2014 10:20:22 GMT

Hi,
Use this expression in city.equals("Pune") expression filter in tMap.
Thanks,
Bhanu

Re: [resolved] transformations

Anonymous — Mon, 25 Aug 2014 10:22:51 GMT

hi Bhanu,
but where am i locate this expression in tMap

Thanks,
Sam

Re: [resolved] transformations

Anonymous — Mon, 25 Aug 2014 11:06:23 GMT

hi Everybody,
i have three tables from which i makes join all together now i want to fetch records by giving two queries for one table so how can i handle it.
thank you.

Re: [resolved] transformations

Anonymous — Wed, 27 Aug 2014 11:35:26 GMT

hi Vaibhav,
can you please tell me is that possible to fetch mail-id's from salesforce and send them Email?
if yes,can you please Justify?
thank you,
Sam

Re: [resolved] transformations

Anonymous — Wed, 27 Aug 2014 12:02:56 GMT

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

Re: [resolved] transformations

Anonymous — Tue, 02 Sep 2014 13:22:58 GMT

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

Re: [resolved] transformations

Anonymous — Mon, 08 Sep 2014 08:49:57 GMT

Hi,
Talend has tSendMail component which can send mail based on particular activity. Please refer to following documentation and scenario example which sends mail on error.
https://help.talend.com/search/all?query=tSendMail%25C2%25A0
Thanks
Vaibhav