Table of Contents

Search

  1. Preface
  2. Introduction to Mapping Specifications
  3. Mapping Specification Configuration
  4. Mapping Specification Objects
  5. Mapping Specification Profiles
  6. Sharing Mapping Specification Logic

Mapping Specification Guide

Mapping Specification Guide

Adding and Editing an Advanced Filter

Adding and Editing an Advanced Filter

Add an advanced filter to filter data by multiple values on columns. After you add an advanced filter, you can edit it to modify the filter values and target columns.
  1. From the Actions menu, click
    Edit
    Filter
    .
    The
    Edit Mapping Specification
    wizard appears.
  2. Select
    Advanced Filter
    .
  3. On the
    Functions
    tab, select a function, click the arrow icon and select a column, and click
    OK
    to add the function to the
    Expression
    editor.
  4. Optionally, in the
    Columns
    tab, select a column and click the add icon to add the column to the
    Expression
    editor.
  5. Select one of the following optional choices to perform a filter task:
    • Optionally, on the
      Rules
      tab, select a rule and click the add icon to add the rule column to the
      Expression
      editor.
    • Optionally, on the
      Lookup
      tab, select a lookup and click the add icon to add the lookup column to the
      Expression
      editor.
    • Optionally, enter an expression in the
      Expression
      editor.
    • Optionally, click
      Validate
      to validate the expression.
    • Optionally, click
      Refresh
      to preview the data.
  6. Click
    OK
    and
    Save
    .

0 COMMENTS

We’d like to hear from you!