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.