Use the DataUpdate node to make DataUpdate mappings, which update any existing database fields with new information. You cannot use this node to delete or insert fields that currently exist in a database; to perform these operations, use either a DataDelete node or a DataInsert node respectively.
For each type of DataUpdate mapping that is listed below, the number of rows that are updated depends on how many rows satisfy the user-specified condition. The condition is usually an operation involving one or more columns in the table. The tool generates the condition as a function of primary keys of the table.
One-to-one mappings are also allowed; in this case, the target column takes the value of the mapped input element. These insert statements can also be combined to produce a single insert that inserts several columns into the same row, as each insert statement creates a new row.
Edit the final WHERE clause of the combined mapping. Each pre-combination mapping already has a WHERE clause.