https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306248#M77816 <P>This is because your output columns need to be set to List. Change the column types in your output schema of your tAggregateRow component</P> Thu, 16 Aug 2018 09:11:01 GMT Anonymous 2018-08-16T09:11:01Z https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306245#M77813 <P>Hi,</P> <P>&nbsp;</P> <P>Please advise me for below question. Thank you so much!</P> <P>&nbsp;</P> <P>The situation is I have different POs with multiple time and I am trying to only get the latest time for each PO. for now I have no idea to achieve what I want.</P> <P>&nbsp;</P> <P>Sample data is below -&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 268px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzwM.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144943iBD088F145C74FFBA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzwM.jpg" alt="0683p000009LzwM.jpg" /></span></SPAN></P> <P>&nbsp;</P> Tue, 14 Aug 2018 21:10:09 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306245#M77813 Anonymous 2018-08-14T21:10:09Z https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306246#M77814 <P>Use a tAggregateRow and group by your PO. Then select the&nbsp;Max function for the Date output column.</P> Wed, 15 Aug 2018 15:05:43 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306246#M77814 Anonymous 2018-08-15T15:05:43Z https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306247#M77815 Thank you. I think it works! <BR />I have another issue after I run. I select "list(object)" for the operations function for other columns but I got incompatible errors. I just want to get output but not use any function for other column. I did not find the general one in function so I choose "list" or "list(object)" but it did not work. Please advise me. Thank you again! Wed, 15 Aug 2018 21:30:32 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306247#M77815 Anonymous 2018-08-15T21:30:32Z https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306248#M77816 <P>This is because your output columns need to be set to List. Change the column types in your output schema of your tAggregateRow component</P> Thu, 16 Aug 2018 09:11:01 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-the-latest-time-in-Talend/m-p/2306248#M77816 Anonymous 2018-08-16T09:11:01Z