How to get the latest time in Talend

[Anonymous]

Hi,

Please advise me for below question. Thank you so much!

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.

Sample data is below - 

[Anonymous · Accepted solution]

Use a tAggregateRow and group by your PO. Then select the Max function for the Date output column.

[Anonymous]

Thank you. I think it works!
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!

[Anonymous]

This is because your output columns need to be set to List. Change the column types in your output schema of your tAggregateRow component