Find first and last data with group by

[MCANTAL1639145723]

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]

Yes, tAggregateRow component can fit your need. 

Here is the online documentation of tAggregateRow component. 

https://help.talend.com/r/en-US/8.0/processing/taggregaterow

Regards

Shong