Mapping File Columns to Attributes

You must map columns in the file with the attributes of the Reltio data model before the data load.

This task explains how to define a mapping between file columns and entity attributes before loading entities. When you click CONTINUE after selecting the file, you are prompted to select an existing mapping or create a new one as follows:
  1. Select an existing mapping.

    You can search for an existing mapping from the list.

    Note: Abstract entity types are not available for mapping.
    You can sort existing mappings in the ascending or descending order based on:
    • The user who created the mapping
    • The date on which the mapping was created
    See the Select mappings Dialog Box image, which explains the mappings that are sorted based on the descending order of the Created date:

    See the Select mappings image, which explains the mappings that are sorted based on the ascending order of Created by:

    You can also filter mappings to refine your search.

    If you select an existing mapping, the CSV columns are mapped to entity attributes based on how the mapping is defined:

  2. In the Select mapping window, click Create New.

    The Create new mapping dialog box is displayed.

  3. Enter a name for the mapping.
  4. From the drop-down list, select the Entity type .
  5. Click the First line of the file is a header option.

    The option enables you to set the first line of the file as the header.

  6. Click a column header.
    You can map the file columns to entity attributes.
  7. From the right panel, select the required attribute.
  8. On the Mapping column, click the filter icon.

    You can filter the attributes. You can choose to view all attributes, non-hidden attributes, or required attributes.

    See the Mapping image, which explains all the non-hidden attributes that are displayed.

    The hidden attributes have the eye symbol against them.

    The first name and Full Name columns are mapped to First Name and Full Name attributes respectively:

    You can unmap attributes by clicking on the cross icon alongside the mapped attribute on top of a column as highlighted in the image above. The Full Name column is mapped to the First Name and Full Name attribute in the image above. The following image shows that the Full Name attribute is unmapped when you click the cross icon.

    You can add a default value to any attribute (simple or nested) without mapping the attribute to any column of the input file.

  9. Select a single column for an attribute.
    On the right panel, the list of attributes will be displayed.
  10. On the right panel, select multiple columns for a single attribute.

    You can map multiple columns to a simple attribute.

  11. Click the Gear icon corresponding to the attribute.

    You can add the value of the attribute.

  12. Enter the value for DomainType.

    You may add this value as the default value. For example, the default value for the DomainType attribute is set to reltio.com

  13. Select the Empty option.

    In one of the mapped columns from the input file, for the missing values, you can set default values or remove values from the tenant during partial override.

  14. Next to the relevant attribute, click the gear icon:

  15. Click More Options. .
  16. Select Split Column.

    The Split column dialog box is displayed:

  17. From the drop-down list, select the separator.
    In this example, the space separator is used. The Preview shows the splitted values.
  18. Click APPLY.
    The name column is splitted into two columns. You can split First name and Last name using the separator as follows.

  19. Click More Options. on the column.
  20. Select Join Column:

    The Join column dialog box is displayed.

  21. From the drop-down list, select the separator. In this example, the space separator is used.

    The Preview shows the joined values.
  22. Click APPLY.
    A new column called Prefix 1 is created that displays the joined values of the prefix and name columns.