Table.ReplaceRows

Table.ReplaceRows

Replaces the specified range of rows with the provided row(s).

function (table as table, offset as number, count as number, rows as list) as table

Description

Replaces a specified number of rows, count, in the input table with the specified rows, beginning after the offset. The rows parameter is a list of records.

Category

Table.Row operations

Examples

Starting at position 1, replace 3 rows.

Table.ReplaceRows(Table.FromRecords({[Column1=1], [Column1=2], [Column1=3], [Column1=4], [Column1=5]}), 1, 3, {[Column1=6], [Column1=7]})

Table.FromRecords({[Column1=1],[Column1=6],[Column1=7],[Column1=5]})