Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this article
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Generates a dynamic array holding a series of equally spaced values.
range(
start,
stop [,
step])
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
start | scalar | ✔️ | The value of the first element in the resulting array. |
stop | scalar | ✔️ | The maximum value of the last element in the resulting array, such that the last value in the series is less than or equal to the stop value. |
step | scalar | The difference between two consecutive elements of the array. The default value for step is 1 for numeric and 1h for timespan or datetime . |
A dynamic array whose values are: start, start + step, ... up to and including stop. The array is truncated if the maximum number of results allowed is reached.
Note
The range function supports a maximum of 1,048,576 (2^20) results.
The following example returns an array of numbers from one to eight, with an increment of three.
print r = range(1, 8, 3)
Output
r |
---|
[1,4,7] |
The following example returns an array with all dates from the year 2007.
print r = range(datetime(2007-01-01), datetime(2007-12-31), 1d)
Output
r |
---|
["2007-01-01T00:00:00.0000000Z","2007-01-02T00:00:00.0000000Z","2007-01-03T00:00:00.0000000Z",.....,"2007-12-31T00:00:00.0000000Z"] |
The following example returns an array with numbers between one and three.
print range(1, 3)
Output
print_0 |
---|
[1,2,3] |
The following example returns a range of hours between one hour and five hours.
print range(1h, 5h)
Output
print_0 |
---|
1,000,000 |
["01:00:00","02:00:00","03:00:00","04:00:00","05:00:00"] : |
The following example returns a truncated array as the range exceeds the maximum results limit. The example demonstrates that the limit is exceeded by using the mv-expand operator to expand the array into multiple records and then counting the number of records.
print r = range(1,1000000000)
| mv-expand r
| count
Output
Count |
---|
1,048,576 |