Four Stars

Talend Compare Date(Time Stamp) and get the most recent Time stamp

Hello!
I want to read the date from ODS and update these data to DWH with most recent data.  Here is the example :
Time                                              Data
2015-04-21 17:37:58                         A 
2015-04-21 17:37:58                         B
2015-04-22 19:37:58                         C  
2015-04-23 20:37:58                         D      
At there,  i just want to  update  the lignes       "2015-04-23 20:37:58          D "  where is the most recent data. 
How could i do with the talend ?       
Here i have some idea, but doesn't work                  input ---->   tmap-----> tfilterRow----->output
select distinct  Time in ODS   and  use tFilterRow to chose the most recent Time  
But how could i write the code in tFilterRow ?? 
Could you help me pls!Smiley Happy
2 REPLIES
Moderator

Re: Talend Compare Date(Time Stamp) and get the most recent Time stamp

Hi,
Could you please take a look at a related forum:https://www.talendforge.org/forum/viewtopic.php?id=36664 to see if it works for your case?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Talend Compare Date(Time Stamp) and get the most recent Time stamp

Hi, Sabrina 
The link you give is not valid,  could you rewrite the link pls ? 
thx