Power Query
published
Search
⌃K

Table.Repeat

Table.Repeat

Repeats the rows of the tables a specified number of times.
function (table as table, count as number) as table

Description

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

Category

Table.Row operations

Examples

Repeat the rows in the table two times.
Table.Repeat(Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "world"]}), 2)
Table.FromRecords({ [ a = 1, b = "hello" ], [ a = 3, b = "world" ], [ a = 1, b = "hello" ], [ a = 3, b = "world" ] }, { "a", "b" })