Table.ReplaceMatchingRows
Replaces all the specified rows with the provided row(s).
function (tableas table,replacementsas list, optionalequationCriteriaas nullable any) as table
Replaces all the specified rows in the
table with the provided ones. The rows to replace and the replacements are specified in replacements, using {old, new} formatting. An optional equationCriteria parameter may be specified to control comparison between the rows of the table.Table.Membership
Replace the rows [a = 1, b = 2] and [a = 2, b = 3] with [a = -1, b = -2],[a = -2, b = -3] in the table.
Table.ReplaceMatchingRows(Table.FromRecords({[a = 1, b =2], [a = 2, b = 3], [a = 3, b = 4], [a = 1, b = 2]}),{ {[a = 1, b = 2], [a = -1, b = -2]}, {[a = 2, b = 3], [a = -2, b = -3]} })
Table.FromRecords({ [ a = -1, b = -2 ], [ a = -2, b = -3 ], [ a = 3, b = 4 ], [ a = -1, b = -2 ] }, { "a", "b" })
Last modified 4yr ago