Use Field Groups

Field groups are filters used to create subsets of data in a Target field. Based on values in another related field, these subsets can have different settings that define whether the field is required or which rules run against the field. If, for example, a field is required only under certain data conditions, field groups are used to define the conditions, fields, values, and requirement setting.

By default, field groups use the default (*) filter, indicating that all data in the table is available for mapping.

Subsets of data can be based on a field group in the Source table or the Target table.

If the filter table is the Source table (for example, Filter Table: MARA, Source Database Object in Map: Mara), begin by configuring the field group:

  1. Create Field Groups.
  2. Assign a Field Group to an Object.
  3. Extend a Field to a Field Group.

Continue by mapping the field group fields (as in, the subset of fields in the Source table):

  1. Select dspMigrate in the Navigation pane.
  2. Click Map in the Context bar.
  3. Click the Targets icon on the Design page.
  4. Click the Sources icon for a Target.
  5. Click the Mappings icon for a Source in the child pane.
  6. Map each field for the field group. Refer to Perform Field Mapping for more information.

If the filter table is the Target table (for example, Filter Table: MARA, Target: ttMara), begin by configuring the field group:

  1. Create Field Groups.

  2. Assign a Field Group to an Object.

  3. Extend a Field to a Field Group.

  4. Add the filter field to the Target table.

    NOTE: If the filter field does not exist on the Target table, create Manual Rules instead of creating field groups. This method saves time as a user does not have to create a relationship for each field group field. Refer to Manual Rules for more information.

Continue by mapping the field group fields (as in, the subset of fields in the Target table):

  1. Select dspMigrate in the Navigation pane.

  2. Click Map in the Context bar.

  3. Click the Targets icon on the Design page.

  4. Click the Field Groups icon for a Target.

  5. Click the Mappings icon for the field group in the child pane.

  6. Map the fields with the Source Details of {Target Rules}. Refer to Perform Field Mapping for more information.

If the filter table is not the Source table (for example, Filter Table: MARA, Source Database Object in Map: Marc or Filter Table: MARA, Source Database Object in Map: F0411), begin by configuring the field group:

  1. Create Field Groups.
  2. Assign a Field Group to an Object.
  3. Extend a Field to a Field Group.

Continue by mapping the field group fields:

  1. Select dspMigrate in the Navigation pane.

  2. Click Map in the Context bar.

  3. Click the Targets icon on the Design page.

  4. Click the Sources icon for a Target.

  5. Click the Mappings icon for a Source.

  6. Assign a relationship to each of the mappings with a Where clause on the Vertical View of the Relationship Joins page to establish which filter is applied. Refer to Add Relationship Joins to Sources for more information.

    Or

    Enter a Where clause for the mapping on the Vertical View of the Field Mappings page.

NOTE: Enter the source table name before the field name in the Where clause.