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


---

# Normal values

# Normal values {#ariaid-title1}

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

A normal value replaces similar but ambiguous field values with one standard
value.

## Field value variations {#c_WhatFieldNormalizationDoes__section_qkk_3jw_x1b}

Records values can come from multiple sources such as:

* Automated entries made by Discovery.
* Automated entries made by importing records from external systems or files.
* Manual entries made by users.

{#c_WhatFieldNormalizationDoes__ul_vgd_k21_x1b}Each of these sources may describe the same field value in several different forms. For example, the CPU Type field on a computer CI form might display any of the following similar values:

* E3350 (Intel) 4.5.2234
* Intel Xeon 5.4.554
* Xeon L3350
* L3350
{#c_WhatFieldNormalizationDoes__ul_q4v_5kz_xp}  
Without normalization, these variant field values results in:

* Duplicate CPU types
* Poor search results
* Complex queries and conditions to apply business logic
{#c_WhatFieldNormalizationDoes__ul_srv_q3w_x1b}

Creating a normal value record solves these issues by consolidating on one standard value such
as <kbd class="ph userinput">Xeon</kbd>.

## Identifying variations with aliases and rules

Each Normal value record specifies how to identify variations of a normal value using a
combination of aliases and rules.

Aliases

:   Aliases are known variations of an input value that normalization converts to the normal
    value. Use aliases when there is a short list of variant values.

    For example, you could create a normal value <kbd class="ph userinput">Xeon</kbd> that has these aliases.

    * E3350 (Intel) 4.5.2234
    * Intel Xeon 5.4.554
    * Xeon L3350
    * L3350
    {#c_WhatFieldNormalizationDoes__ul_jjc_2w1_x1b}  
    Whenever a normalization data job or normalized query sees a field value matching an alias, it automatically replaces the field value with the normal value. Normalization data jobs and queries process aliases before rules.  
    Note:  
    Aliases are logically equivalent to rules using the \[is\] operator in a condition where \[Field name\]\[is\]\[Alias value\]. For example, the sample aliases are equivalent to these rules: \[CPU Type\]\[is\]\[E3350 (Intel) 4.5.2234\] OR \[CPU Type\]\[is\]\[Intel Xeon 5.4.554\] OR \[CPU Type\]\[is\]\[Xeon L3350\] OR \[CPU Type\]\[is\]\[L3350\]

Rules

:   Rules specify the conditions under which normalization replaces an input value with the
    normal value. Use rules when there are a large number of possible variant values, or when you
    must create complex conditions.

    For example, the normal value <kbd class="ph userinput">Xeon</kbd> could have this rule.

    \[CPU Type\]\[matches regex\]\[.\*\\bxeon\\b.\*\]

    Whenever a normalization data job or normalized query sees a field value matching a rule,
    it automatically replaces the field value with the normal value. Normalization data jobs and
    queries process rules after aliases.

    Rules and aliases can be combined to normalize a field. Make sure to test your
    normalization methods before applying them to all the existing records in the database.

## Normalized queries

An administrator can configure normalization to apply to queries issued against normalized
fields in lists. Select the Normalize query check box on the
Normalization form to enable this functionality. In a list containing normalized values, [Filters and breadcrumbs](https://www.servicenow.com/docs/access?context=c_UsingFiltersAndBreadcrumbs&version=xanadu&pubname=xanadu-platform-user-interface&ft:locale=en-US) using the original (raw) value for the normalized field in the query
condition.  
Figure 1. Normalized query example

The filtered list returns records with the normal value substituted for the raw value.
However, the breadcrumbs for the filter display the original query conditions.  
Figure 2. Normalized query results

## Scripting and normalization {#c_WhatFieldNormalizationDoes__section_cmg_5wp_x1b}

Scripts that update or insert records into the database (GlideRecord) are normalized
automatically when field normalization is applied. For example, if a script to insert a CI
record contains a CPU type of Xeon L3350, the script is normalized to
insert the CI with a CPU type of Xeon instead. Scripts that query the
database for normalized field values (using the conditions of equals or not equals) can be
configured to return the normal value (such as Xeon) rather than the
original (raw) value.
* **[Create the normalization record](https://servicenow-prod.fluidtopics.net/k7rcFthbSLvvOg9icBbYXQ)**   
  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.
* **[Create a normal value](https://servicenow-prod.fluidtopics.net/tes9lr70YQ~Zaz70gjZd3g)**   
  A normal value is a simplified, generic value for a field that replaces all the possible variants of that value that exist in the database.
* **[Create aliases](https://servicenow-prod.fluidtopics.net/JXApYMND2YJH7z4siTp6zg)**   
  Aliases are the variants of a field value in the instance that will be replaced by the normal value.
* **[Apply aliases](https://servicenow-prod.fluidtopics.net/zCVI6CmXW9ppSRXv3r7~WA)**   
  After testing, aliases can be normalized in all new records or in existing records when they are updated.
* **[Create rules](https://servicenow-prod.fluidtopics.net/gt3jP6nn_9g9YV6VeGomWg)**   
  The use of rules to normalize a field is intended for large lists of variant field values.
* **[Coalesce records on a normal value](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.

**Related topics**   

* [GlideRecord](https://www.servicenow.com/docs/access?context=p_GlideServerAPIs&version=xanadu&pubname=xanadu-application-development&section=c_GlideRecord&ft:locale=en-US)