Table.Repeat

Repeats the rows of the tables a specified number of times.

Syntax

Table.Repeat(
    table as table,
    count as number
) as table

Remarks

Returns a table with the rows from the input table repeated the specified count times.

Examples

Example #1

Repeat the rows in the table two times.

Table.Repeat(
    Table.FromRecords({
        [a = 1, b = "hello"],
        [a = 3, b = "world"]
    }),
    2
)

Result:

Table.FromRecords({
    [a = 1, b = "hello"],
    [a = 3, b = "world"],
    [a = 1, b = "hello"],
    [a = 3, b = "world"]
})

Category

Table.Row operations