---
schema_version: "1"
id: f40ad9c866c883ba5e9968369f31f32eca8cb50f308cb27808cc0f7346d7a1cc
title: update Parameters
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_update_operation.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_update_operation.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8a86a3363922234442a75915ffd2b2a627a16fab77c26a7c3d1cd4ce571e215e
description: When you define an update transformation, you set the action attribute to update and specify the parameters.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# 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.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28964e44">Parameter</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28964e47">Required?</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28964e50">Value</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e44 ">left</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e50 ">Node in the dataflow definition file that identifies the dataset that contains
              the records that you want to update.</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e44 ">right</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e50 "> Node in the dataflow definition file that identifies the lookup dataset that
              contains the new values.</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e44 ">left_key</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e50 ">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 <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_update_transformation.htm&amp;release=264.0.0&amp;type=5" title="The update Transformation updates the specified field values in an existing dataset based on data from another dataset, which we call the lookup dataset. The transformation looks up the new values from corresponding fields in the lookup dataset. The transformation stores the results in a new dataset.">update Transformation</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e44 ">right_key</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e47 ">Yes</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e50 ">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.</td>

          </tr>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e44 ">update_columns</td>

            <td data-label="Required?" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e47 ">No</td>

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d28964e50 ">
              <p>An array of corresponding columns between the left and right dataset. Use
                the following syntax: <code>"update_columns": {
                    "LeftColumn1": "RightColumn1", "LeftColumn2": "RightColumn2",... "LeftColumnN":
                    "RightColumnN" }</code>. The value from right column replaces the value from
                the corresponding left column. The field types of the left and right columns must
                match.</p>
              <p>If you specify a column name that does not exist, the dataflow
                fails.</p>
              <p style="margin-bottom:0;">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.</p>
            </td>

          </tr>
        </tbody>
      </table>

#### See Also

- [update Transformation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_update_transformation.htm&release=264.0.0&type=5 "The update Transformation updates the specified field values in an existing dataset based on data from another dataset, which we call the lookup dataset. The transformation looks up the new values from corresponding fields in the lookup dataset. The transformation stores the results in a new dataset.")