Link Search Menu Expand Document

Update Row in Table

Category: Table

This activity allows you to update existing rows in a table. To use this activity, you need to provide:

  1. An input table to make updates to
  2. The columns you want to update
  3. The new values for those columns
  4. Criteria for selecting rows to update

In the Table section of the activity’s properties, you configure the first three of these items. This sample shows how to update the username column with a new value of cbauch:

In the Select section, you configure the criteria for selecting rows. You can either select to update all of the rows in the table or provide criteria in the where clause. This sample shows a clause that will only update rows where the id is equal to a variable:


Writing a Where Clause

See the Where Clauses page.


Hints

  • If this activity isn’t letting you select the table you want, check that the activity creating the table has Persist Table checked on its properties.

Sample Workflows

The following sample workflows are available in our repository’s workflows folder to help you get familiar with this activity. These can be imported using the instructions here or you can view the workflow in GitHub by clicking on it.