rowNo

Syntax

rowNo(X)

Arguments

X is a vector.

Details

Return the index position of each row in a table.

Examples

team=1 1 1 1 1 2 2 2 2 2
id=1..5 join 2..6
x=11..20\2
t=table(team, id, x)
t;
team id x
1 1 5.5
1 2 6
1 3 6.5
1 4 7
1 5 7.5
2 2 8
2 3 8.5
2 4 9
2 5 9.5
2 6 10
select * from t where rowNo(id)%3=0;
team id x
1 1 5.5
1 4 7
2 3 8.5
2 6 10
update t set teamFirst=(rowNo(id)==0) context by team;
t;
team id x teamFirst
1 1 5.5 1
1 2 6 0
1 3 6.5 0
1 4 7 0
1 5 7.5 0
2 2 8 1
2 3 8.5 0
2 4 9 0
2 5 9.5 0
2 6 10 0