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 ().
3. Change the column attributes. Based on the column datatype, you can set these attributes.

   Attribute	Description
   Label	The display label for the column, the one that appears in charts and dashboards. The column label can each be up to 255 characters.
   API Name	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.
   Precision	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. Note 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.
   Scale	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.
   Length	The maximum number of characters in a text column. Enter an integer from 1 through 32000, inclusive. The default length is 255 characters.
   Date Format	The date format of a date column.

   For more guidelines, see the “Field Name Restrictions” section in this help topic.

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 ().
6. Click Save.