whichever

There are other concepts named whichever. See the entire list.

whichever, table modifier

The whichever modifier on a by table creation keeps one arbitrary row per group and copies vectors from the source table.

Example

table T = with
  [| as Code, as X |]
  [| "FR", 1 |]
  [| "US", 2 |]
  [| "UK", 3 |]
  [| "FR", 1 |]

table Countries[c] = whichever by T.Code

show table "Countries" with
  c
  Countries.X

This outputs the following table:

c X
FR 1
UK 3
US 2

Remarks

Use whichever only when any representative row is acceptable.

User Contributed Notes
0 notes + add a note