update Parameters

When you define an update transformation, you set the action attribute to update and specify the parameters.

This table describes the input parameters.

Parameter	Required?	Value
left	Yes	Node in the dataflow definition file that identifies the dataset that contains the records that you want to update.
right	Yes	Node in the dataflow definition file that identifies the lookup dataset that contains the new values.
left_key	Yes	Key column in the left dataset used to match records in the other dataset. If you use a composite key, the left and right keys must have the same number of columns in the same order. For an example, see update Transformation.
right_key	Yes	Key column in the right dataset used to match records in the other dataset. If you use a composite key, the left and right keys must have the same number of columns in the same order.
update_columns	No	An array of corresponding columns between the left and right dataset. Use the following syntax: `"update_columns": { "LeftColumn1": "RightColumn1", "LeftColumn2": "RightColumn2",... "LeftColumnN": "RightColumnN" }`. The value from right column replaces the value from the corresponding left column. The field types of the left and right columns must match. If you specify a column name that does not exist, the dataflow fails. If you do not specify this parameter, the transformation updates the left dataset by matching all columns in the right dataset with the columns in the left. In this case, the right column names must match exactly with the left column names. Otherwise, an error occurs.

Product Area