Table of Contents

Search

  1. Preface
  2. Introduction to Reference Data
  3. Reference Tables in the Analyst Tool
  4. Reference Data in the Developer Tool
  5. Classifier Models
  6. Probabilistic Models
  7. Reference Data and Informatica Data Engineering Integration

Reference Data Guide

Reference Data Guide

Finding and Replacing Values

Finding and Replacing Values

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.
  1. Click
    Open
    .
    The asset library opens.
  2. Select the
    Reference Tables
    asset category, and select a reference table name.
    The reference table opens in read-only mode.
  3. 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.
  4. Click
    Actions
    Find and Replace
    .
    The
    Find and Replace
    toolbar appears.
  5. 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.
  6. Use the following options to replace values one by one or to replace all values:
    • Use the
      Next
      and
      Previous
      options to find values one by one.
    • To replace a value, select
      Replace
      .
    • To display all instances of the value, select
      Highlight All
      .
    • To replace all instances of the value, select
      Replace All
      .

0 COMMENTS

We’d like to hear from you!