Find first and last data with group by

MCANTAL1639145723 · ‎2024-03-12

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 · ‎2024-03-12

Yes, tAggregateRow component can fit your need.

Here is the online documentation of tAggregateRow component.

Regards

Shong