Remove Unmapped Source Values

While value mapping, if a Source has many values that are not used (as in, only the values in the Target table must be value mapped), a Migration Developer can remove them before importing the Target table. Removing unused Source values allows a user to more easily value map, as only relevant Source values display.

Before this task can be performed, the lookup table must have been created or imported and a mapping with the Xref or RuleXref action must be created.

To remove the unused Source values:

  1. Click Map in the Context bar.

  2. Click the Targets icon on the Process Area Launch page.

  3. Click the Mappings icon for a Target.

  4. Click the link for a lookup table used in the value mapping in the LOOKUP field.

    NOTE: This type of mapping uses an Xref or RuleXref action.

  5. Click the Sources icon.

  6. Click the Vertical View icon for the Source used in the value mapping.

  7. Click the Remove Values icon.

    NOTE: All values are removed in the Source field (stored in the Source data source) that have not yet been value mapped to a Target table. Use this feature only if the remaining values in the Source field should not be mapped to the Target field (as in, when mapping a field with an Xref action and processing objects in Transform.)

  8. Click the Target Table Import icon.

The import loads only those values that must be value mapped.