--- sourceDocument: Brazil ServiceNow AI Platform Administration sourceDocumentLink: https://www.servicenow.com/docs/r/platform-administration Release : - brazil ft:locale : - en-US ft:publication_title : - Brazil ServiceNow AI Platform Administration ft:clusterId : - platadm bundleId : - platadm workflow : - Platform --- # Field normalization and transformation # Field normalization and transformation {#ariaid-title1} Release version: Brazil Updated September 10, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of Field normalization and transformation Field normalization and transformation in ServiceNow Brazil release enhance data integrity and reduce duplication by standardizing field values. These processes modify input data to ensure consistency and meaningfulness, improving search results and data quality across the platform. Show full answer Show less ## Normalization Normalization identifies variations of the same field value and consolidates them into a single preferred value. This eliminates duplicate records and improves query accuracy by replacing entered values with normalized ones automatically. It is especially effective for descriptive fields such as names or units of measurement. * Example use cases: Standardizing CPU types (e.g., "Xeon") or corporate suffixes (e.g., "ServiceNow, Inc.") ## Transformation Transformation converts raw input values into standardized, organization-specific formats based on defined rules and conditions. Administrators set these rules, which can perform actions like removing name suffixes or rounding numerical values. * Example use cases: Removing suffixes like "Jr." from usernames or rounding RAM sizes to whole numbers * Rules are ordered and can halt processing when a condition is met, providing control over transformation flow ## Enabling Normalization and Transformation by Field Type ServiceNow supports normalization and transformation on specific field types by default: * **String and URL fields:** Support both normalization and transformation * **Decimal, Float, Integer, Numeric fields:** Support transformation only Administrators can add support for additional data types but should avoid applying normalization or transformation directly to Sys ID fields to prevent data corruption. Instead, normalize or transform their display values. ## Identifying Normalized Fields The system marks fields with normalization or transformation applied by displaying an icon. Users with the **normalizer** role can access the related rules by clicking the icon, while others see a help page. Administrators can control icon visibility using the "Restrict to roles" preference. Field Normalization includes normalization and transformation, which are two different ways to alter field values for increased data integrity and reduced duplication. ## Normalization {#c_FieldNormalization__section_e5h_b1s_w1b} Normalization searches for variations of the same field value and converts them into a single preferred value. By consolidating multiple variations of the same value into a single simple recognizable value, the system eliminates duplicate records and provides better search results. When a process or a user enters a value in a normalized field, the system determines whether to replace it with a normal value. Normalization also automatically adjusts queries to return normalized results and normalizes values in scripts. While normalization is available for every field in the platform, it works best for descriptive values such as names or standard units of measurement. For example, you might create normalization rules to: * Set the CPU type of a computer CI to a standard model name such as Xeon. * Set the suffix used for the names of corporations to a standard format such as ServiceNow, Inc.. {#c_FieldNormalization__ul_kpg_btz_w1b} ## Transformation {#c_FieldNormalization__section_kqn_c1s_w1b} Transformation converts raw field input values into standardized values that are more meaningful to an organization. Administrators control when transformation happens by defining rules and conditions for specific fields. For example, you might create transformation rules to: * Remove suffixes from user names such as Jr. and II. * Round computer CI RAM sizes to the nearest whole number such as rounding 4112 MB to 4000 MB. {#c_FieldNormalization__ul_q3s_lsz_w1b} Transform records make up the rules that define how a field transformation is executed. Order values determine the order in which each rule is evaluated. A check box on each transform enables an administrator to determine where processing stops when a rule evaluates to true. ## Enabling normalization and transformation by field type {#c_FieldNormalization__section_arz_m4z_w1b} Field type records specify which data types are available for normalization and transformation. By default, the system supports normalization and transformation for these field types. {#c_FieldNormalization__table_g1p_dfz_w1b__entry__3} | Field type | Use to normalize | Use to transform | |-|-|-| | Decimal | false | true | | Float | false | true | | Integer | false | true | | Numeric | false | true | | String | true | true | | URL | true | true | [ ] {#c_FieldNormalization__table_g1p_dfz_w1b} A field type entry applies to all fields whose dictionary entry data type matches the field type entry. Administrators can create additional field type records for other data types as needed. Warning: Avoid creating field type records for fields that store a Sys ID value such as a reference field, field name field, or a table name field. Directly altering a Sys ID value is more likely to produce data corruption and broken references than to produce meaningful standard values. Instead, normalize or transform the display value associated with the Sys ID. For example, normalize the user name instead of the Sys ID of a specific user. ## Identifying normalized fields {#c_FieldNormalization__section_ryb_gxp_x1b} The system displays the normalization icon ![Normalization icon]() on fields with an associated normalization or transformation record. Users with the normalizer role can click the icon to access the associated normalization or transformation record. Users without the normalizer role instead see a help page. Administrators can configure who sees the normalization icon with a preference called Restrict to roles.