last
last(T.A : ‘a) sort T.B : ‘b 🡒 ‘a, aggregator
The aggregator requires a sort
option to be specified and returns the last value for each group.
Example:
table T = with
[| as A, as B |]
[| "hello", "a" |]
[| "hello", "a" |]
[| "hello", "b" |]
[| "world", "b" |]
[| "world", "c" |]
table G[gdim] = by T.B
where T.B != "c"
show table "" a1b4 with
gdim
last(T.A) sort T.A
group by gdim
The sort
option can be applied to any ordered data type. When the group is empty, the default value for the data type is used.