Hi, Just one question, with aggregate function, when we use aggregate function, I want to have the first or the last value from one culum sorted with the date. I see that we can sum, min, max..... but i don see the possibility to use the first or last record. Do you have one typ to do ? In the pi…

You can use the "Enumerate rows" action to enumerate rows for each date. Then use the "Keep min/max" action for the row numbers grouped by dates. "The smallest 1" mode will return you the first value, "the biggest 1" - the last one. See the example below: first-in-group.morph (3.7 KB) [image]

EasyMorph Community - Data preparation professionals and enthusiasts

Aggregate + first or Last value

To learn more about EasyMorph visit easymorph.com.