topic Re: Find first and last data with group by in Talend Studio

Find first and last data with group by

MCANTAL1639145723 — Tue, 12 Mar 2024 22:00:44 GMT

Hi,

I have datas like this :

And I need to find for each mag and day, the first and last Num of the day.

In my example, the result must be :

How to do in Talend ? With tAggregateRow ?

Thanks.

Shicong_Hong — Wed, 13 Mar 2024 02:48:19 GMT

Yes, tAggregateRow component can fit your need.

Here is the online documentation of tAggregateRow component.

Regards

Shong