Work with Date formats during Column Mapping

Depending on the formatting and the content of the source file being uploaded, the mapping interface may display columns with date values in supported, unsupported, or both date formats.

Reltio natively supports common date formats. For more information on Reltio-supported Date formats, see Understanding the Reltio Attribute Type.

However, if a source file contains dates in an unsupported format, you do not need to transform date values in uncommon data format into supported formats before uploading a source file. Data Loader can accept and transform date values in any date format virtually. You can explicitly define the patterns of uncommon date formats used in Data Loader job files. Data Loader can accurately parse timestamps and transform applicable date values before loading them into mapped attributes that use standard and officially supported date formats.

Mapping a column that contains dates in one of the supported formats is achieved through the standard mapping steps.
  1. Select a column in the source file.
    The column can contain date values.
  2. Select the date from the list of attributes to which it will be mapped.
    For example, in the following image, you can easily map the supportedDate column to Activation Date.

  3. Select the UnsupportedDate column.

    Selecting an attribute will help you to allow Data Loader to map this to a date-typed attribute and load the column’s data correctly.
  4. Choose a date attribute from the list of attributes to which it will be mapped.

    In this example, the Deactivation Date is selected.

    See the following example in which the UnsupportedDate column contains dates in an unsupported format.

  5. Click the gear icon next to Deactivation Date.

  6. Select Input Data Format and enter the pattern of the date format in the field.
    Note: This input field is available for Date/Time/Timestamp simple attributes only. It will not appear if you map a date type column from a source file to a regular simple attribute of string type in Reltio L3.

    Selecting an attribute will help you to allow Data Loader to map this to a date-typed attribute and load the column’s data correctly.
    In this scenario, the user would enter dd.MM.yyyyy. Reltio does not support the native format, but providing this definition of the data type while configuring mapping allows Data Loader to convert the raw values from the input file to a supported format while loading them into the mapped attributes on the corresponding.

    To know more information about the date and time patterns, see Simple Date Format.