DocTable Examples: Update

Here I show how to update data into a DocTable. In addition to providing updated values, DocTable also allows you to create map functions to transform existing data.

Single Update

Update multiple (or single) rows with same values.

Apply as Map Function

This feature allows you to update columns based on the values of old columns.

Apply as Set of Ordered Map Functions

This is useful for when the updating of one column might change the value of another, depending on the order in which it was applied.

Update Using SQL WHERE String