argFirst

argFirst() 🡒 boolean, process

Returns true for the first value of the group according to the ordering. The group is optional. When the group is provided, the function returns true once per group.

table T = with
  [| as N, as G |]
  [| 0, "b" |]
  [| 3, "a" |]
  [| 2, "a" |]
  [| 1, "a" |]

T.A = argFirst() sort T.N
T.B = argFirst() by T.G sort T.N

show table "" a1c3 with
  T.N
  T.G
  T.A
  T.B

See also