Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Dictionaries

Dictionaries

Running a query on a large dictionary

Running a query on a large dictionary

You can create a filter query to retrieve data from the full set of dictionary values. The filter options are available in very large dictionaries.
For information about very large dictionaries and the pagination limits that can apply to them, see Working with very large dictionaries.
You build a filter query on dictionary column values. For example, you can create a query that can retrieve rows with given values in a column that you select.
  1. On the
    Configuration
    view, click
    Add Filter
    .
  2. In the
    Add Filter
    dialog box, click the '+' symbol to add a condition.
  3. Choose a column and an operator for the condition. If required, add a value that the query can look for in the column.
  4. Add more conditions if required.
  5. If you add multiple conditions, choose one of the following options:
    • All. Data Quality retrieves any row that meets all of the conditions.
    • Any. Data Quality retrieves any row that meets at least one of the conditions.
  6. Click
    Apply
    .
To edit a query, click
Edit Filter
in the
Configuration
pane.

0 COMMENTS

We’d like to hear from you!