Map

Remove Unmapped Source Values

While value mapping, if the value mapping tables contain values that are not in scope for the migration, a user can remove them quickly using buttons on pages as described in this section. The value mapping tables can be populated with out of scope values, for example, when users build rules in Transform and then process the target object prior to implementing the rules in Transform to identify active records. In this case, the value mapping tables could contain, for example, all country or payment codes when only a subset of those values are needed for mapping.

This functionality allows value mapping tables to be cleaned up quickly and for value mapping statistics to be updated to reflect the accurate values that have not yet been value mapped.

Values that are removed have:

Values can be removed at three different levels:

  1. Wave

  2. Wave / Check Table / Source

  3. Wave / Check Table / Source / Table / Field

Access to the buttons that allow source values to be removed at various levels depends on a user’s assigned WebApp group.

Users from these WebApp groups cannot remove values at the wave level:

  • Read Only

  • FieldMapper

  • FieldAndValueMapper

To remove the not required source values at the wave level:

  1. Click Advanced Data Migration in the Navigation pane.

  2. Click Map in the Context bar.

  3. Select Configuration > Wave Lookup Table Refresh in the Navigation pane.

  4. Select the wave containing the values.

  5. Click the Remove Values button on the Page toolbar.

Users from these WebApp groups cannot remove values at the check table level:

  • Read Only

  • ValueMapper

  • FieldMapper

To remove the unused values at the wave / source / check table level:

  1. Click Advanced Data Migration in the Navigation pane.

  2. Click Map in the Context bar.

  3. Click the Value Mapping icon on the Process Area Launch page.

  4. Click the Mappings icon for a check table.

  5. Click the check table name link in the LOOKUP column on the Field Mappings page next to a mapping with Xref or RuleXref action.

  6. Click the Sources icon.

  7. Click the Remove Values button in the Page toolbar.

Users from these WebApp groups cannot remove values at the field level:

  • Read Only

  • ValueMapper

  • FieldMapper

To remove the unused Source values at the wave / check table/ source / table / field level:

  1. Select Advanced Data Migration in the Navigation pane.

  2. Select Map in the Context bar.

  3. Select Configuration > Value Mapping (Config) in the Navigation pane.

  4. Click the Sources icon for a check table.

  5. On the Value Mapping (Sources) page, click the Source Config button for the Source that has values that need to be removed.

  6. On the Source Check Table (Config) page, click the Tables button.

  7. Click the Remove Values icon for the row containing the source table / field for which the value needs to be deleted.