topic Re: Filter row by max date in Talend Studio

Filter row by max date

EnriqueLDE — Sat, 16 Nov 2024 05:04:26 GMT

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!

Re: Filter row by max date

Anonymous — Mon, 05 Aug 2019 16:58:17 GMT

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 🙂

Re: Filter row by max date

EnriqueLDE — Tue, 06 Aug 2019 07:54:35 GMT

Hi Manish,

Thank you very much, it works perfectly!

Kind regards,

Enrique