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!