Power Query
Search…
published
Powered By GitBook
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.
1
Table.ReplaceRows(Table.FromRecords({[Column1=1], [Column1=2], [Column1=3], [Column1=4], [Column1=5]}), 1, 3, {[Column1=6], [Column1=7]})
Copied!
Table.FromRecords({[Column1=1],[Column1=6],[Column1=7],[Column1=5]})
Last modified 3yr ago