Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Step 7. Define a Filter

Define the data that the subscription consumes by setting filter conditions on table columns in the

Filter

page of the subscription wizard.

If data relations are defined for the topic to which the subscription subscribes, filters are applied to the tables for which the relations are defined, and the subscriber consumes only the data that is defined by the data relations.

You can use basic expressions and advanced expressions to define filter conditions. You can use more than one method to add filters to a table row.

Basic Expression: Use this method if you want to apply a condition to a table row and the operators and values in the basic condition builder meet your requirements. For example, for an Orders table, add a condition that the date in the ShippedDate column is greater than April 1, 2015.
Advanced Expression: Add filter conditions to tables with PowerCenter expressions. For example, for an Orders table, add the following expression:

(ShipCountry=’USA’) and ((ShipCity=’New York’) or (ShipCity=’Los Angeles’))

The filters use an AND logic. If multiple filters exist for a table,

Data Integration Hub

writes only the rows that meet all of the conditions to the target.

Choose the type of expression that you want to create.

Select the table to which to apply the filter from the

Select Table

list.

Enter the condition parameters according to the method that you selected:

Basic expression: go to step 4.

Advanced expression: go to step 5 .

To create a basic expression, perform the following steps:

Select the column to filter from the

Select Column

list.

Select the filter operator from the

Select Operator

list.

The available operators depend on the type of content in the column.

When

Select Value

is enabled, select or enter a value for the operator.

Values of string operators can contain up to 90 digits. Values of numeric operators can contain up to 15 digits.

Click the plus icon to the right of the expression line.

The condition shows in the condition list.

To create an advanced expression, perform the following steps:

Enter a valid PowerCenter expression in the text field. Alternatively, prepare a basic expression, select

Advanced Expression

, and then, in the expression text area, complete the expression.

The expression is limited to the selected table. The expression can contain up to 1024 characters.

Click the plus icon to the right of the expression line.

The condition shows in the condition list.

Repeat steps 1 through 5 to add the required conditions.

Click

The

Schedule

page appears.

Creating an Automatic Relational Database Subscription

Creating an Automatic Flat File Subscription

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

Step 7. Define a Filter

Step 7. Define a Filter