---
schema_version: "1"
id: 1d7c6a9fe31a862a5f96ebca7055e6a0544c3370db2fbd64731b3cf95000ce72
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/data/264-0-0/c360_a_batch_transform_edit_attributes.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_edit_attributes.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 110d5dc8000e8b508a5f099f009dd05cdf21aac82069438ee43192fbfcb8ffd2
description: Use the Edit Attributes transformation to make column names more descriptive and apply consistent formats to column values. You can set the labels and API names of all columns. You can also set the precision and scale for numeric columns, character length for text columns, and date formats for date columns.
products:
  - Data 360
release: "264"
---
# Edit Attributes Transformation: Change the Column Names and Value Formats

Use the Edit Attributes transformation to make column names more descriptive and apply consistent formats to column values. You can set the labels and API names of all columns. You can also set the precision and scale for numeric columns, character length for text columns, and date formats for date columns.

1. In the Transform node, 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-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/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-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/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="d74007e47">Attribute</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d74007e49">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e47 ">Label</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e49 ">
                  <p style="margin-bottom:0;" id="c360_a_batch_transform_edit_attributes__p_label_description"><a name="c360_a_batch_transform_edit_attributes__p_label_description"><!-- --></a>The display label for the column, the one that appears in
                    charts and dashboards. The column label 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="d74007e47 ">API Name</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e49 ">
                  <p style="margin-bottom:0;" id="c360_a_batch_transform_edit_attributes__p_apiname_description"><a name="c360_a_batch_transform_edit_attributes__p_apiname_description"><!-- --></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 batch data
                    transform.</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e47 ">Precision</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e49 ">
                  <div id="c360_a_batch_transform_edit_attributes__p_precision_description"><a name="c360_a_batch_transform_edit_attributes__p_precision_description"><!-- --></a>
                    <p>The maximum number of digits in a numeric 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.</p>
                    <div class="slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium">
                      <div class="slds-media slds-media_responsive">
                        <div class="slds-media__figure"><span class="slds-icon_container slds-icon_container_circle slds-icon-note-note"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png" alt="Note"></span></div>
                        <div class="slds-media__body" style="padding-top:.5rem;padding-bottom:.5rem;"><span class="slds-text-title_caps">Note</span> If a numeric value
                          exceeds the specified precision, the value is set to 0 or null. For example, if
                          precision is set to 5, the numeric value is replaced with null.</div>
                      </div>
                    </div>
                  </div>
                </td>
              </tr>
              <tr class="">
                <td data-label="Attribute" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e47 ">Scale</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e49 ">
                  <p style="margin-bottom:0;" id="c360_a_batch_transform_edit_attributes__p_scale_description"><a name="c360_a_batch_transform_edit_attributes__p_scale_description"><!-- --></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="d74007e47 ">Length</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e49 ">
                  <p style="margin-bottom:0;" id="c360_a_batch_transform_edit_attributes__p_length_description"><a name="c360_a_batch_transform_edit_attributes__p_length_description"><!-- --></a>The maximum number of characters in a text 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="d74007e47 ">Date Format</td>
                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d74007e49 ">
                  <p style="margin-bottom:0;" id="c360_a_batch_transform_edit_attributes__p_dateformat_description"><a name="c360_a_batch_transform_edit_attributes__p_dateformat_description"><!-- --></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 canvas, click the **Collapse** button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_collapse.png)).
6. Click **Save**.