Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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! 0683p000009MACn.png
Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi,
Could you please take a look at a related forum: https://community.talend.com/t5/Design-and-Development/Compare-a-date-to-the-current-date/td-p/10578... to see if it works for your case?
Best regards
Sabrina
Anonymous
Not applicable
Author

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