repeat()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Generates a dynamic array containing a series comprised of repeated numbers.
Syntax
repeat(value, count)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| value | bool, int, long, real, datetime, string or timespan |
✔️ | The value of the element in the resulting array. |
| count | int |
✔️ | The count of the elements in the resulting array. |
Returns
If count is equal to zero, an empty array is returned. If count is less than zero, a null value is returned.
Examples
The following example returns [1, 1, 1]:
T | extend r = repeat(1, 3)