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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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