Data normalization

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Certain types of data extracted from documents are converted into a standard format so that they appear the same across all fields.

    This process increases the usefulness of the data by enabling it to be grouped and analyzed more easily. It also supports integration with other applications on the ServiceNow AI Platform.

    Field types

    The following field types are converted to support data normalization:

    Field type Description
    Date Standard date format. For example, YYYY-MM-DD.
    Integer Whole number. For example, 12.
    Decimal Number with up to two decimal places. For example, 12.5 or 12.55.
    Floating point number Number with up to seven decimal places. For example, 12.0 to 12.0000000.

    To set the field type, see Create a field.

    Display

    A completed data extraction field shows the converted value next to it.

    Data extraction integer field and its converted value field.Data extraction date field and its converted value field.

    You can adjust the converted date value by selecting Edit.

    Note:
    In some cases, the data extracted from the document may not be in a valid format to be converted. For example, if DocIntel read the letter O instead of a number 0 in a date field (11.12.2o23), then it would not be converted. In this case, edit the field to the correct format.