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]})

Table.ReplaceRelationshipIdentity

Table.ReplaceValue

Last modified 4yr ago