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!