Tabular OperatorsOther Operators Generates a single-column table of values in an arithmetic sequence.
range columnName from start to stop step step
Generate values from start to stop (inclusive) with the given step increment.
| Name | Description |
|---|
| columnName | Name of the output column |
| start | Starting value (int, long, real, datetime, or timespan) |
| stop | Ending value (inclusive if exactly reachable) |
| step | Increment between values (must be same type as start/stop, or timespan for datetime) |
range year from 793 to 1066 step 50
| year (long) |
|---|
| 1043 |
| 793 |
| 843 |
| 893 |
| 943 |
| 993 |
range day from datetime(2024-06-01) to datetime(2024-06-07) step 1d
| day (datetime) |
|---|
| 2024-06-01T00:00:00Z |
| 2024-06-02T00:00:00Z |
| 2024-06-03T00:00:00Z |
| 2024-06-04T00:00:00Z |
| 2024-06-05T00:00:00Z |
| 2024-06-06T00:00:00Z |
| 2024-06-07T00:00:00Z |
range watch from 0h to 24h step 4h
| watch (timespan) |
|---|
| 00:00:00 |
| 04:00:00 |
| 08:00:00 |
| 1.00:00:00 |
| 12:00:00 |
| 16:00:00 |
| 20:00:00 |
range oar_position from 1 to 30 step 1
| oar_position (long) |
|---|
| 1 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 2 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 3 |
| 30 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |