Creates an action to update the rows in {0} based on the set of operations in {1}. The action returns a table containing the updated rows as they appear in {0} after the action executes.
The value of {1} may be a single
{{columnName, columnFunction}}
pair or a list of such pairs. For each pair, thecolumnFunction
is the function to apply to a row to compute the new value for thecolumnName
column for that row.To update a subset of the rows in {0}, use
Table.SelectRows
to apply a filter to {0} before usingTableAction.UpdateRows
.The function raises an evaluation error if {0} is not updatable or if any of the operations in {1} are incompatible with {0}.
The action raises an execution error if the operation fails.
NOTE: {0} may be left in a partially updated state if an execution error occurs.