Configure Global Table Attributes data connections

Using these columns, map the fields in the table attribute to the fields in the external data.

• Identity Director tries to match fields based on the field names, and creates mappings for matched fields.
  • You can edit or delete the mappings created by Identity Director.
  • You must manually create mappings for columns that are added after the data connection is created.
  • You must manually update the mapping for a column, if the name of the column changes.
  • Automatic mapping is only performed when you create the data connection, and after you delete all mappings (created automatically and manually).
• You can add mappings for fields that Identity Director did not match.
• You can use placeholders and functions to create custom patterns.
  Example:
  Combine the FirstName and LastName fields from a Data Source in the Name field of a table attribute.
  
  For more information about placeholders and functions, please see the Identity Director Help.

Use this option if you want to map data from multiple columns in a Data Source, to multiple rows in one column of a table attribute.

• Each field in the table attribute can only be mapped once per group.
• Not all fields have to be included in every group.

Example:
Import data from the columns Address1 and Address2 from a Data Source as multiple rows in the Addresses column in a table attribute.

Explanation

Data Source:

Department	Address1	City1	Address2	City2
Engineering	12 Grimmauld Place	London	9764 Jeopardy Lane	Chicago

Desired result in the global table attribute 'Address List':

Adresses	Cities
12 Grimmauld Place	London
9764 Jeopardy Lane	Chicago

To achieve this result, create the following groups and mappings: