Salesforce Docs Portal

Number to Text Transformation: Convert the Column Type

To group and filter by a numeric column, use the Number To Text transformation. You can group and filter by text columns only.

  1. In the Transform node, select the number column that you want to convert to the Text column type.
  2. In the Transform toolbar, select Number to | Text.
    The To Date modal provides options to specify the date format.
  3. Under Show Results In, select whether the new values appear in a new column and whether to keep the original column.
  4. If you elect to create a column, set the label under Column Label.
  5. To change more column attributes, click the Column Attributes box, change them, and click Apply.
    The Column Attributes box shows the API Name, Output Type, and Length for the resulting dimension column.
  6. Based on the output column’s datatype, you can set these attributes.
    Attribute Description
    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 between 1 and 18, inclusive.

    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 between 0 and 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 between 1 and 32000, inclusive. The default length is 255 characters.
    Date Format The date format of a date column.
    For more guidelines, see Field Name Restrictions in Analytics External Data Format Developer Guide: External Data Metadata Format Reference.
  7. To add the transformation to the Transform node, click Apply. The Preview tab shows the text column.
  8. To view the canvas area, click the Collapse button (Collapse button).

Run the batch data transform to convert the column type to Text.