Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Table.ReplaceRows(table as table, offset as number, count as number, rows as list) as table
About
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.
table
: The table where the replacement is performed.offset
: The number of rows to skip before making the replacement.count
: The number of rows to replace.rows
: The list of row records to insert into thetable
at the location specified by theoffset
.
Example 1
Starting at position 1, replace 3 rows.
Usage
Table.ReplaceRows(
Table.FromRecords({
[Column1 = 1],
[Column1 = 2],
[Column1 = 3],
[Column1 = 4],
[Column1 = 5]
}),
1,
3,
{[Column1 = 6], [Column1 = 7]}
)
Output
Table.FromRecords({
[Column1 = 1],
[Column1 = 6],
[Column1 = 7],
[Column1 = 5]
})