topic Talend Compare Date(Time Stamp) and get the most recent Time stamp in Talend Studio https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221794#M15649 Hello! <BR />I want to read the date from ODS and update these data to DWH with most recent data. &nbsp;Here is the example : <BR />Time &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Data <BR />2015-04-21 17:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; <BR />2015-04-21 17:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B <BR />2015-04-22 19:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C &nbsp; <BR />2015-04-23 20:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D &nbsp; &nbsp; &nbsp; <BR />At there, &nbsp;i just want to &nbsp;update &nbsp;the lignes &nbsp; &nbsp; &nbsp; "2015-04-23 20:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D " &nbsp;where is the most recent data.&nbsp; <BR />How could i do with the talend ? &nbsp; &nbsp; &nbsp;&nbsp; <BR />Here i have some idea, but doesn't work &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;input ----&gt; &nbsp; tmap-----&gt; tfilterRow-----&gt;output <BR />select distinct &nbsp;Time in ODS &nbsp; and &nbsp;use tFilterRow to chose the most recent Time &nbsp; <BR />But how could i write the code in tFilterRow ??&nbsp; <BR />Could you help me pls! <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> Tue, 21 Apr 2015 17:02:53 GMT Anonymous 2015-04-21T17:02:53Z Talend Compare Date(Time Stamp) and get the most recent Time stamp https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221794#M15649 Hello! <BR />I want to read the date from ODS and update these data to DWH with most recent data. &nbsp;Here is the example : <BR />Time &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Data <BR />2015-04-21 17:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; <BR />2015-04-21 17:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B <BR />2015-04-22 19:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C &nbsp; <BR />2015-04-23 20:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D &nbsp; &nbsp; &nbsp; <BR />At there, &nbsp;i just want to &nbsp;update &nbsp;the lignes &nbsp; &nbsp; &nbsp; "2015-04-23 20:37:58 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D " &nbsp;where is the most recent data.&nbsp; <BR />How could i do with the talend ? &nbsp; &nbsp; &nbsp;&nbsp; <BR />Here i have some idea, but doesn't work &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;input ----&gt; &nbsp; tmap-----&gt; tfilterRow-----&gt;output <BR />select distinct &nbsp;Time in ODS &nbsp; and &nbsp;use tFilterRow to chose the most recent Time &nbsp; <BR />But how could i write the code in tFilterRow ??&nbsp; <BR />Could you help me pls! <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> Tue, 21 Apr 2015 17:02:53 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221794#M15649 Anonymous 2015-04-21T17:02:53Z Re: Talend Compare Date(Time Stamp) and get the most recent Time stamp https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221795#M15650 Hi, <BR />Could you please take a look at a related forum: <A href="https://community.qlik.com/s/feed/0D53p00007vCpzWCAS" target="_blank" rel="nofollow noopener noreferrer">https://community.talend.com/t5/Design-and-Development/Compare-a-date-to-the-current-date/td-p/105783</A>&nbsp;to see if it works for your case? <BR />Best regards <BR />Sabrina Wed, 22 Apr 2015 09:37:20 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221795#M15650 Anonymous 2015-04-22T09:37:20Z Re: Talend Compare Date(Time Stamp) and get the most recent Time stamp https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221796#M15651 Hi, Sabrina&nbsp;<BR />The link you give is not valid, &nbsp;could you rewrite the link pls ?&nbsp;<BR />thx Thu, 23 Apr 2015 09:54:59 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Compare-Date-Time-Stamp-and-get-the-most-recent-Time/m-p/2221796#M15651 Anonymous 2015-04-23T09:54:59Z