---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Transforms

# Transforms {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Transforms update field values by applying a transformation definition to the field
contents such as replace text, change case, or round value.

## Transform definitions {#c_FieldTransformations__section_gqb_v2w_x1b}

Transform definitions define the transformation actions available for a given field type.
Administrators select a definition when they transform a field, and then provide the definition
with the specific parameters that are applied to the transformation. For example, a definition
can round up an integer or insert a value at a defined position in a string.

The system provides a number of definitions that are designed to meet the needs of most
organizations, but administrators can create new definitions as needed. Transform definitions
can be associated with existing Transform Categories or to new categories.

## Transform categories {#c_FieldTransformations__section_ofw_gky_y1b}

Transform categories are used to group the transform definitions together appropriately to
present to users when creating new field transforms. You can create new categories for existing
definitions or change the default associations of categories to definitions.  
Transform categories are associated with normalization field types to present the correct definition option list for the field being transformed. The base system provides two transform categories: Text and Numeric.

Text
:   Definitions in the Text category transform string type field values. Included in the Text
    category are:

    * Left
    * Right
    * Constant
    * Trim
    * Prefix
    * Suffix
    * Change Case
    * Delete
    * Insert
    * Substring
    * Replace
    {#c_FieldTransformations__ul_emk_sky_y1b}

Numeric
:   Definitions in the Numeric category arithmetically manipulate integer type field values.
    Included in the Numeric category are:

    * Limit
    * Round
    * Constant
    {#c_FieldTransformations__ul_f21_kky_y1b}

## Transformation testing mode {#c_FieldTransformations__section_oyh_jly_y1b}

Transformation is a powerful tool that can cause data issues if used incautiously. Test all
transformations before committing the changes to the CMDB.

All transformation records open in Test mode by default, which blocks
administrators from running manual data jobs that apply changes to existing data. Only users
with the normalization_tester role can transform data when a record is in the
Test mode. This is limited to new records opened by the tester or
records in which the transformed field is updated by the tester.

To apply transformations to the CMDB after testing, change the mode to
Active in the transformation record and run the appropriate data job.
For information on testing transforms, see [Test a transform](https://servicenow-prod.fluidtopics.net/opAHK8KlUFsuWEngIEBvzg#t_TestATransform "Verify the transform changes the field value as desired before applying them to existing records in the database.").
* **[Transform a field](https://servicenow-prod.fluidtopics.net/opAHK8KlUFsuWEngIEBvzg#t_TransformAField)**   
  Transform the contents of field using a set of rules and conditions.