Normalize a field Field normalization converts different varieties of the same field value, to a single, preferred value. When a process or a user enters a value in a normalized field, the platform determines if that value can be replaced with a normal value. By forcing a field to use a simple, recognizable description for multiple variations of the same value, normalization can eliminate duplicate records and make searches easier. Normalization also automatically adjusts queries to return normalized results and normalizes values in scripts. Field normalization is available for every field in the platform, with the exception of reference fields. However, some fields are more likely to be normalized than others, such as the CPU type field. Another obvious candidate for normalization is the Name field in the Company table. Company names might appear in records in several different forms (for example, Inc., Incorporated, Corporation). Normalized fields can eliminate confusion by providing logical replacements for ambiguous values. What field normalization doesRecords for things like devices and companies are brought into the ServiceNow platform by manual entry, imports, and Discovery.Data jobs created by field normalizationField Normalization creates four data jobs during the normalization process to collect or change data.Create the normalization recordRegardless 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.Roll back data jobsHow to roll back data jobs.Create a normal valueA 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 aliasesAliases are the variants of a field value in the instance that will be replaced by the normal value.Create rulesThe use of rules to normalize a field is intended for large lists of variant field values.Coalesce records on a normal valueCoalescence 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.Create a raw fieldA 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.Identify normalized fieldsNormalized fields are marked with an icon that links to different targets, depending on the user's role.