Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ReplaceRows

Owen Duncan|Last Updated: 4/19/2018

About

Returns a table where the rows beginning at an offset and continuing for count are replaced with the provided rows.

Table.ReplaceRows(table as table, offset as number, count as number, rows as list) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
offsetThe beginning row index.
countThe number of rows to replace.
rowsThe List of replacement rows.

Remarks

  • Table.ReplaceRows is similar to List.ReplaceRange but requires a table as input.

Example

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