Data Management Console: Group and Replace

In the synonym editor, the Group and Replace option provides a new user interface to simplify adding a field that groups together similar related values.

To implement Group and Replace, right-click a field in the synonym editor, point to New Expression, and click Group and Replace.

A group field is created with all values ungrouped.

You can create new subgroups either by selecting Create a new group from the pull-down menu, or by right-clicking a value on the list and clicking Make a new group.

Once you have created a subgroup, you can drag values into that subgroup, as shown in the following image. To facilitate this operation, Double List was selected from the Display option on the pull-down menu.

The options available on the pull-down menu are shown in the following image.

You can perform the following operations using this menu.

• Display the group frame as a single list or a double list.
• Add all of the values to a group.
• Ungroup all of the values.
• Recreate groups phonetically using either the Metaphone or Soundex algorithm. Soundex calculates a code for alphanumeric values so that if they sound the same but are spelled differently, they will still have the same code. Metaphone is an improved version of Soundex that takes into account anomalies in English spelling and pronunciation.
• Edit the properties of the group field, such as its name.
• Hide the group card.