Mapping Specification Filters
Add filters to a mapping specification to limit the data that appears in the mapping specification results. When you add a filter, you can specify the filter conditions to use in the filter.
You can add the following types of filters:
- •Simple filter. Applies to multiple values and operators on source columns.
- •Advanced filter. Applies to expressions, functions, and rules on source columns.
Adding and Editing a Simple Filter
Add a simple filter to filter data by a fixed value on a column. After you add a simple 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. Chose to add or edit a filter.
- - To add a filter, click the New icon.
- - To edit a filter, click the Edit icon.
The New Filter or Edit Filter wizard appears.
3. Select Simple filter.
4. On the Condition panel, select a column, operator, and enter a value.
5. Optionally, on the Data Preview panel, click the Refresh icon to preview the data.
6. Click OK.
The Filter Properties panel displays the filter condition.
7. Optionally, click the Edit icon or the Delete icon to edit or delete the filter.
8. Click Save.
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.