[resolved] transformations

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

Thanks,
Sam

[Anonymous]

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.

[Anonymous]

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