Loading
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Text to Number Transformation: Convert the Column Type

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Text to Number Transformation: Convert the Column Type

            To perform a mathematical calculation on the column, such as calculating the average, use the Text To Number transformation to change the Text column type to Number. You can perform mathematical calculations on numeric columns only. Numeric types include the percent data type.

            During the column type conversion, the Dimension to Measure transformation rounds decimals to the nearest whole number. For example, 300.2939 becomes 300.

            1. In the Transform node, select the dimension column that you want to convert to the Measure column type.
            2. In the Transform toolbar, select Dimension to | Measure.
              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, Precision, and Scale for the resulting measure column.
            6. Based on the output column’s data type, you can set these attributes.
              AttributeDescription
              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.

              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.
              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 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 measure column.
            8. To view the canvas area, click the Collapse button (Collapse button).

            Run the data transform to convert the column type to measure.

             
            Loading
            Salesforce Help | Article