Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Profiles
  3. Part 2: Profiling with Informatica Analyst
  4. Part 3: Profiling with Informatica Developer

Profile Guide

Profile Guide

Applying Filters to Drilldown Data

Applying Filters to Drilldown Data

You can filter the drilldown data iteratively so that you can analyze data irregularities on the subsets of profile results.
  1. Select a column value on the
    Values
    tab.
  2. Right-click and select
    Drilldown
    .
    The drilldown results appear in the
    Data Preview
    pane.
  3. To add a filter condition, right-click a column value in the
    Data Preview
    pane, and select
    Add to Filter
    .
    The
    Drilldown Filter
    dialog box appears with the filter condition.
  4. Add the required filter conditions, and click
    OK
    .
    You cannot apply drill-down filters to inferred data types.
  5. To save the filter, click
    Actions
    Save Filter
    .
  6. To clear the drilldown filters, click
    Actions
    Refresh
    .
  7. To export drilldown data to a Microsoft Excel spreadsheet, click
    Actions
    Export Data
    .

0 COMMENTS

We’d like to hear from you!