---
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


---

# Transform a field

# Transform a field {#ariaid-title1}

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

Transform the contents of field using a set of rules and conditions.

## Before you begin

Role required: admin or normalizer

## Procedure

1. Create a transformation record.
2. Create one or more related transform records.
3. Test the transform.
4. Runs data jobs.
{#t_TransformAField__steps_ohl_4gs_w1b}

## What to do next

If you want to also show what the original (raw) input value was prior to transformation, create a raw field to store this value.

## Create a transformation record {#ariaid-title2}

Creating a transformation record is the first step in transforming a
field.

### Procedure

1. Activate the Field Normalization plugin.
2. Navigate to Field NormalizationConfigurationsTransformations.
3. Click New.
4. Create a transformation record.  
   {#t_CreateATransformationRecord__table_ppz_nfs_w1b__entry__2}

   | Field | Description |
   |-|-|
   | Name | Unique name for this transformation record. This value is for reference only and is not used in any processing. |
   | Table | Select the ServiceNow table containing the field being transformed. It is important to understand the table hierarchy when setting up a field transform. For example, if you configure transformation for a field in the Computer \[cmdb_ci_computer\] table, that field will be transformed for all workstation machines, Windows servers, Linux servers, and UNIX servers. |
   | Field | Select the field to transform. The list presented contains only those field types (integer and string) from the table selected that can be transformed. Note: The sys_user record that initiates the transform process must have its date format set to the default format of "yyyy-MM-dd." Any other date format causes an error during transformation. This problem is only specific to transforming TO TARGET fields of type Date/Time. This problem is not an issue if the target field type is of type String or if the field mapping for the date field is changed to the same date format as the transformation process. |
   | Mode | The three available modes are Off, Test, and Active. All transformation records are created in the test mode by default. Do not change the mode until you have thoroughly tested the transformation. When testing is complete, change the mode to Active. To disable this transformation, switch the mode to Off. |
   | Normalize query | Select this check box to apply the field value transformed by this record to all queries involving this field. Queries issued with the raw (original) field value will be edited to use the transformation value. |
   | Raw field | Select the field to use to display the original input (non-normalized) values on a form in which a field value has been normalized. For the selection to appear in the drop-down list, add a custom field to the form for the table selected. For instructions on adding a field for raw data, see [Create a raw field](https://servicenow-prod.fluidtopics.net/gCbSfy0YMWvoVs_FK2nF8g "A raw field is a custom field created by an administrator to show the original (raw) input in a field on a form after it has been normalized or transformed."). |
   [Table 1. Transformation record fields]

   {#t_CreateATransformationRecord__table_ppz_nfs_w1b}
5. Click Submit.  
   The Transforms and Data Jobs
   Related Lists appear on the form.

## Create one or more related transform records {#ariaid-title3}

Each related transform record performs a specific transformation type such as adding
characters to the beginning of the value or replacing one string for another. You may need
to create multiple related transform records to generate a preferred output field
value.

### Procedure

1. In the Transformation record, select the Transforms Related List.
2. Click New.  
   A selection list of transform types appears, displaying only those
   transformations appropriate for the field type selected.  
   Figure 1. Transform types
3. Select a transform type and provide the appropriate parameters.
4. Select an Order number for this transform.  
   Note:  
   The conditions for the transforms are executed according to the order numbers assigned.
5. Select the Final check box to stop processing with this transform if the condition evaluates to true.
6. Select the Case sensitive check box to force case sensitivity in the condition statement.  
   The following transform example replaces the INC at the
   beginning of an incident number with the string ENG if the
   assignment group is ITSM Engineering.  
   Figure 2. Transformation record
7. Click Submit.  
   The new Transform appears in the Related List of the Transformation
   record.

   When the Transform is created, a Transformation application data job is also
   created. This data job applies this transform to appropriate records in the
   entire database and should not be run until testing is complete.
8. **Optional:** Repeat steps 2 through 8 until the output value meets your desired criteria.

## Test a transform {#ariaid-title4}

Verify the transform changes the field value as desired before applying them to
existing records in the database.

### About this task

Note:  
Users must have the normalization_tester role to create test records.

New transformation records open in the Test mode by default,
enabling administrators to test transforms thoroughly before applying them to the
existing records in the database. In the test mode, the Start
controls are not available for the Transform application data
job. There are two methods, listed below, for testing transforms before committing
the transformations to existing data.

### Procedure

* Manually create or update test records.  
  In the test mode, only records that have been created or updated by a user
  with the normalization_tester role are transformed. Grant the normalizer and
  normalization_tester roles to the same user or grant them to separate
  users.
* Use the Test transforms utility to enter a raw value and see the resulting transformed value.  
  This feature enables a normalization tester to transform field values on the
  fly without opening or updating records. This utility tests all the
  transforms configured for this field.
  1. Open a Transformation record.
  2. Click the Test transforms Related Link.  
     A dialog box appears for testing field values.
  3. Enter a value to transform in the Raw data field.  
  4. Click OK.  
     The platform transforms the raw value in the Transformed data field.  
  5. Enter new raw data to test other transforms.
  6. Click Cancel to end the test.
  7. When testing is complete, change the Mode to Active and run the data job.
  {#t_TestATransform__substeps_flp_rb5_qq}

*[\>]: and then