extend.range

extend.range, function

def table extend.range(count: number): table

Creates a new table with count rows per input row, and adds a numbering column N running from 1 to count. The function is used with an into clause to bind the input table.

• count: number of rows to create for each input row.

Examples

table Items[Id] = with
  [| as Id |]
  [| "A" |]
  [| "B" |]

table Periods = extend.range(2 into Items)

show table "Expanded" with
  Periods.Id
  Periods.N

This produces the following table:

Errors

extend.range fails if count is negative, non-integer, or would create more than 1 billion rows. Tables produced by extend.range default to a maximum size of 100m lines unless an explicit max constraint is provided.

See also

• secondary dimensions