Filter row by max date

[EnriqueLDE]

Hello,

Im using a .csv with person data and a date. I'm trying to filter by desc date (it means now first row will be max date) and later obtain the max date row (output should have just a single row with max date). I'm not sure about the components i need to use. For example:                                                                                                 

INPUT         

1 | Person1 | 2019-01-01                                               

3 | Person3 | 2019-01-03     

2 | Person2 | 2019-01-02 

(desc) 

3 | Person3 | 2019-01-03   

2 | Person2 | 2019-01-02    

1 | Person1 | 2019-01-01

OUTPUT (max date)

3 | Person1 | 2019-01-03   

Thank you!

[Anonymous · Accepted solution]

Hello ,

By using tsortRow --> tAggregateRow--> tSampleRow you can perform this scenario

1] tSortRow =  desc on date 

2] tAggregateRow = group by on sno. and person_name then in operation :- max function on date

3] tSampleRow= range will be "1,1,"

for more help please find attached snapshots 

thanks, 

Warm Regards,
Manish

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[EnriqueLDE]

Hi Manish,

Thank you very much, it works perfectly!

Kind regards,

Enrique