Home Download Forums Support  

Record filter

Record Filter

The Record filter operation allows you to generate a subset of the rows in a table by applying one or more filter rules.

 

Filter rules

Each filter rules defines a single condition for selecting a set of records in the data. You can create multiple conditions by defining multiple filter rules.

To add a new filter rule click on the Add rule button in the bottom toolbar. There is no limit to the number of rules you can add in a single Record filter operation.

To remove a single rule click on the Remove button or click the Remove all button to remove all of the rules in the operation.

To view or edit the rule click on the expand button  or click on the rule name. Each rule is comprised of 3 elements: 

  1. The name of the field you want to filter by.
  2. The rule you want to apply to the selected field.
  3. The value you want to filter against.
Match criteria

 

The match criteria options are shown at the top of the operation. They determine how the filter rules should be applied to the data. You can choose to either accept or reject the records that match all or any of the filter rules that are defines in the record filter operation.

Example

In the following example we have a data-set containing a list of company employees. The data is shown below.

We will use the Record filter operation to retrieve all Female employees based in London. To achieve this we need to create two filter rules. In the first filter rule we want to obtain all employees based in London. This rule is configured as folllows: 

  1. Field: Location
  2. Rule: =
  3. Value: London 

The result of applying this rule is shown below.

Now we want to add another filter rule. In this rule we want ot obtain all female employees. This rule is configured as follows: 

  1. Field: Sex
  2. Rule: =
  3. Value: London  
In the match criteria section we choose to Accept all records that match all of these rules. By combining these two rules together we are filtering the data to only accept records where Sex=Female and Location=London. The result of applying both of these rules together is shown below.

 

 

Go Back to data-operations.

 

 

Home DataManager Operations Record filter