Component Criteria
You can define filter criteria for data subset components and for data masking components in a plan. Define the filter criteria for each column you need to filter.
You can define expressions to limit data values for specific columns in a data subset operation. You can also limit the value to a percentage of rows, an interval of rows, or to an absolute value. You can disable and enable data masking for a column.
Define filter criteria for a column in the Plan Components panel. Choose the data masking or data subset component to filter.
Filtering Data Subset Components
You can define filter criteria for data subset components at the column level.
1. To create a data subset filter for a column, click the data subset component in the Plan Components panel.
2. Select a column from the Criteria panel to apply the filter to.
Test Data Manager shows existing filter criteria. You can change the filter criteria or add new criteria.
3. Choose a method to filter the column data:
Option | Description |
|---|
Custom | Create a basic expression or an advanced expression to filter the data. |
Limit | Limit the subset results by percentage, by absolute value, or by an interval of rows to write to the target. |
4. If you choose the Custom method, select one of the following options to define a filter:
Option | Description |
|---|
Basic | Define a simple expression that includes just an operator and operand. |
Advanced | Define an expression in the Expression Editor. You can include multiple columns and functions in the expression. |
Disabling Masking for a Column
You can disable or enable masking for a column in the plan.
1. Click a masking component in the Plan Components panel.
2. Select a column from the Criteria panel.
3. To disable masking for the column, click OFF.
4. To enable masking for the column, click ON.