---
schema_version: "1"
id: d68e616db1fa25131287eec5d072b1c65c0aef448259d7a837ea6e691f211713
title: "Edit Attributes Transformation: Change the Column Names and Value Formats"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_transformation_editattributes.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_editattributes.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5da0d7c3b08e2c3afabc2d9711ffbb90ed5fa3da38e4f66bd760396dbdd1c620
description: In CRM Analytics, to make column names more descriptive and apply consistent formats to column values, use the Edit Attributes transformation in a Data Prep recipe. You can set the labels and API names of all columns. You can also set the precision and scale for number columns, character length for text columns, and date formats for date columns.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Edit Attributes Transformation: Change the Column Names and Value Formats

In CRM Analytics, to make column names more descriptive and apply consistent formats to column values, use the Edit Attributes transformation in a Data Prep recipe. You can set the labels and API names of all columns. You can also set the precision and scale for number columns, character length for text columns, and date formats for date columns.

### Required Editions

## Edit Attributes Transformation: Change the Column Names and Value Formats

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d153523e42">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e42 ">To create a recipe:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e42 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

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

1. In a Transform node of a Data Prep recipe, select the column in the Preview tab.
2. In the Transform toolbar, click the Edit Attributes button (![Edit Attributes button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_editAttributes.png)).
    
    ![The Edit Attributes panel shows the column label, API name, precision, and scale for the Amount column.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_editAttributes_edit.png)
3. Change the column attributes.
    
    Based on the column datatype, you can set these attributes.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:19.41747572815534%">
              <col style="width:80.58252427184466%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d153523e87">Attribute</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d153523e89">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e87 ">Label</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e89 ">
                  <p style="margin-bottom:0;" id="bi_integrate_recipe_transformation_editAttributes__d1455e104"><a name="bi_integrate_recipe_transformation_editAttributes__d1455e104"><!-- --></a>The display label for the column, the one that
                    appears in charts and dashboards. Column labels can each be up to 255
                    characters. </p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e87 ">API Name</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e89 ">
                  <p style="margin-bottom:0;" id="bi_integrate_recipe_transformation_editAttributes__d1455e110"><a name="bi_integrate_recipe_transformation_editAttributes__d1455e110"><!-- --></a>The API name of the column. The column API name
                    can each be up to 255 characters. The API name must also be unique within
                    the recipe.</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e87 ">Precision</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e89 ">
                  <p style="margin-bottom:0;" id="bi_integrate_recipe_transformation_editAttributes__d1455e116"><a name="bi_integrate_recipe_transformation_editAttributes__d1455e116"><!-- --></a>The maximum number of digits in a numeric
                    (measure) column. Includes all numbers to the left and to the right of the
                    decimal point (but excludes the decimal point character). Enter an integer
                    from 1 through 18, inclusive. If a numeric value exceeds the specified
                    precision, the value is set to 0 or null, depending on whether null measure
                    handling is enabled. For example, if precision is set to 5 and null measure
                    handling is enabled, the numeric value 123456.78 is replaced with null.</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e87 ">Scale</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e89 ">
                  <p style="margin-bottom:0;" id="bi_integrate_recipe_transformation_editAttributes__d1455e122"><a name="bi_integrate_recipe_transformation_editAttributes__d1455e122"><!-- --></a>The number of digits to the right of the decimal
                    point in a numeric column. Enter an integer from 0 through 17, inclusive.
                    The scale must be less than the precision. For example, if the numeric value
                    is 123456.789 and you set the scale to 2, the number appears as 123456.78.
                  </p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e87 ">Length</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e89 ">
                  <p style="margin-bottom:0;" id="bi_integrate_recipe_transformation_editAttributes__d1455e128"><a name="bi_integrate_recipe_transformation_editAttributes__d1455e128"><!-- --></a>The maximum number of characters in a text
                    (dimension) column. Enter an integer from 1 through 32000, inclusive. The
                    default length is 255 characters.</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e87 ">Date Format</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153523e89 ">
                  <p style="margin-bottom:0;" id="bi_integrate_recipe_transformation_editAttributes__d1455e134"><a name="bi_integrate_recipe_transformation_editAttributes__d1455e134"><!-- --></a>The date format of a date column.</p>
                </td>
              </tr>
            </tbody>
          </table>
    
    For more guidelines, see the “Field Name Restrictions” section in [this help topic](https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_ext_data_format.meta/bi_dev_guide_ext_data_format/bi_ext_data_schema_reference.htm).
4. Click **Apply** to add the transformation to the Transform node.
    
    If applicable, Preview shows the new column label.
5. To view the Graph area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_collapse.png)).
6. Save the recipe.