You can find and replace data values in a reference table. Use the find and replace options when a table contains one or more instances of a data value that you must update.
Click
Open
.
The asset library opens.
Select the
Reference Tables
asset category, and select a reference table name.
The reference table opens in read-only mode.
To edit the current version of the reference table, click
Edit
.
To edit the reference table in a versioned Model repository, check out the reference table.
Click
Actions
Find and Replace
.
The
Find and Replace
toolbar appears.
Enter the search criteria on the toolbar:
Enter a data value in the
Find
field.
Select the columns to search. By default, the operation searches all columns.
Enter a data value in the
Replace with
field.
Use the following options to replace values one by one or to replace all values: