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

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

The following 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:20%">
          <col style="width:20%">
          <col style="width:60%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d16432e44">Parameter</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d16432e47">Required?</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d16432e50">Value</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e44 ">operation</td>

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 ">
              <p>Indicates what the transformation does if it matches multiple rows in the right
                dataset with a row in the left. Valid values:</p>
              <ul>
                <li><code>LookupSingleValue</code>. Returns values from
                  one of the matched rows. If you don’t specify the <code>operation</code> parameter, the transformation uses this operation.</li>
                <li><code>LookupMultiValue</code>. Returns values from all
                  matched rows.</li>
              </ul>
              <p style="margin-bottom:0;">For more information about each operation, see <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_augment_match_operations.htm&amp;release=264.0.0&amp;type=5" title="For each record in the left dataset, the augment transformation performs a lookup to find a matching record in the right dataset. However, it’s critical that you understand how the augment transformation handles special cases when matching records.">Special Cases for Matching Records with the augment Transformation</a>.</p>
            </td>

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

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 ">Node in the dataflow definition file that identifies the left dataset. This is
              one of two input sources for this transformation.</td>

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

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 ">
              <p>Key column in the left dataset used to augment the dataset. If you use a
                composite key, the left and right keys must have the same number of columns in the
                same order. For a composite key, use the following
                syntax:</p>
              <pre class="line-numbers slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium slds-scrollable_x"><code>[ "Key Column1", "Key Column2", …, "Key ColumnN" ]</code></pre>
              <p style="margin-bottom:0;">The left or right key can’t be a multivalue field. A key must be a dimension.</p>
            </td>

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

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 "> Node in the dataflow definition file that identifies the right dataset. This
              is one of two input sources for this transformation.</td>

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

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 ">Relationship between the left and right dataset. The dataflow adds the
              relationship to the beginning of the right column names in the output dataset to
              make the column names unique and descriptive. Can contain only letters, numbers,
              dots, underscores, and dashes.</td>

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

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 ">An array of column names from the right dataset that you want to include in the
              output dataset. The dataflow adds the relationship as a prefix to the column name to
              determine the name of the right column in the output dataset.</td>

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

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

            <td data-label="Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d16432e50 ">
              <p>Key column in the right dataset used to augment the dataset. If you use a
                composite key, the left and right keys must have the same number of columns in the
                same order. </p>
              <p style="margin-bottom:0;">The left or right key can’t be a multivalue field. A key must be a
                dimension.</p>
            </td>

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

#### See Also

- [augment Transformation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_augment_transformation.htm&release=264.0.0&type=5 "The augment transformation adds columns to a dataset from another related dataset. The resulting, augmented dataset enables queries across both related input dataset. For example, you can augment the Account dataset with the User dataset to enable a query to return account records and the full names of the account owners.")