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


---

# Create the normalization record

# Create the normalization record {#ariaid-title1}

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

Regardless of the normalization method selected, all field normalization requires a
list of existing variants and a normal value that is configured to replace these variants in
forms and in queries.

## About this task

Normalize a field by selecting aliases for a normal field value or by creating rules that use condition statements to match field variants with a normal value.  
Note:  
Users must have the normalizer role to create and manage normalization records.

Special Cases  
* Reference fields cannot be normalized. To normalize values appearing in reference fields, normalize the field in the target table. Examples of this would be normalized values for the Name fields in the Company \[core_company\] and Location \[cmn_location\] tables, which are referenced by other tables in the platform. The normalized names are available to all fields that reference these tables.
* Fields in a choice list can be normalized if they are of a type string.
{#t_CreateTheNormalizationRecord__ul_yb4_hqz_xp}

## Procedure

1. [Activate](https://servicenow-prod.fluidtopics.net/DhcO0B1MaohXjJZGpnb9zQ "You can activate most plugins to expand features and functionalities in the ServiceNow AI Platform.") the Field Normalization plugin.
2. Navigate to Field NormalizationConfigurationsNormalizations.
3. Click New.
4. Create a normalization record.  
   {#t_CreateTheNormalizationRecord__table_fr2_vqz_xp__entry__2}

   | Field | Input value |
   |-|-|
   | Name | Unique name for this normalization record. This value is for reference only and is not used in any processing. |
   | Table | Select the ServiceNow table for the field being normalized. |
   | Field | Select the field to normalize. |
   | Mode | The three available modes are Off, Test, and Active. All normalization records are created in the test mode by default. If you are planning to select aliases for your normal values, change the Mode to Active. If you intend to normalize the field using rules, be sure to leave this record in the Test mode. To disable this normalization, switch the mode to Off. |
   | Normalize query | Select this check box to apply the field value normalized by this record to all queries involving this field. Queries formed with the raw (original) field value return records displaying the normal value. Queries issued by a script using the conditions equals or not equals return normalized values. See [Normalized Queries](https://servicenow-prod.fluidtopics.net/6K7ac28X2Tzx06l7SxhUfA "A normal value replaces similar but ambiguous field values with one standard value.") for details. |
   | Coalesce each normal | Select this check box to normalize reference field values. This option resets all references to records containing an alias field value to the record using the normal value. See [Coalesce Normal Values](https://servicenow-prod.fluidtopics.net/3zCdbKQjliLFjgZ_jvElgQ "Coalescence enables an administrator to redirect references to multiple records containing variants of the same field value to point to a single record, based on a normal value.") for details. |
   | Raw field | Select the field to use to display the original (non-normalized) input 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 [Creating 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. Normalization record fields]

   {#t_CreateTheNormalizationRecord__table_fr2_vqz_xp}

   After the normalization record is submitted, the platform runs the Pending
   value collection job in the Data Jobs related list
   automatically to gather all the current values (Pending Values) for the
   field being normalized.  

   Click the Pending Values related list to view values
   for the normalized field that have been entered manually, imported into the
   platform, or created by Discovery.  

*[\>]: and then