Foundation: Data Selection Rules

TimeXtender can filter out specific records loaded into a table using Data Selection Rules. This is similar to using a "WHERE" clause in a SQL statement.

The rules available for data selection are similar to that of conditions. You select a field in the table. You are then able to choose from a number of operators such as Equal, Greater Than, In List, or Like.

Last, you provide a value in which the values in the field are filtered on. TimeXtender does not require the use of single quotes around string values typed in this field.

Similar to a SQL "WHERE" clause, multiple rules can be applied with either an "AND" or an "OR".

To apply multiple rules as an "AND" you click on the existing data selection statement and add a second rule. This will include only records where both rules apply.

Alternatively, if you wish to use an "OR", you right click on the table and add another data selection rule. This will include records where either rule applies.

It is important to know that Data Selection Rules do not load any data into the table that does not fit into the "rule" that is applied. Which means, when applied, this method can reduce load times on larger tables by excluding data.

Later in this training, we will cover an alternative method for removing records from a table through data cleansing and validation rules. This method, however, does not reduce load times because the data is stored for later analysis.