Simple comparisons relationship options
When performing a simple comparison in the Select rows panel, the relationship options define the association between a column and a value in the resulting selection expression.
The Relationship drop-down list contains the options used to specify the association (e.g., equal to, greater than, contains, etc.) between a column and a value. The options available in the list are dependent on the data type of the selected column. For more information about data types, see Data types.
The following relationship options are available when performing a simple comparison in the Select rows panel.
Relationship | Applicable data types | Description |
---|---|---|
= (has the value) |
|
Rows where data in the selected column is identical to the specified value are displayed in the grid. |
≠ (does not have the value) |
|
Rows where data in the selected column contains anything other than the specified value are displayed in the grid. |
> (is greater than) |
|
Rows where the data in the selected column is greater than the specified value are displayed in the grid. |
≥ (is greater than or equal to) |
|
Rows where the data in the selected column is greater than or equal to the specified value are displayed in the grid. |
< (is less than) |
|
Rows where the data in the selected column is less than the specified value are displayed in the grid. |
≤ (is less than or equal to) |
|
Rows where the data in the selected column is less than or equal to the specified value are displayed in the grid. |
is between |
|
Rows where the data in the selected column is between, or equal to, the specified values are displayed in the grid. |
is not between |
|
Rows where the data in the selected column is not between, or equal to, the specified values are displayed in the grid. |
contains |
|
Rows where the data in the selected column contain the entered text string are displayed in the grid. |
does not contain |
|
Rows where data in the selected column does not contain the entered text string are displayed in the grid. |
begins with |
|
Rows where data in the selected column begins with the entered text string are displayed in the grid. |
does not begin with |
|
Rows where data in the selected column does not begin with the entered text string are displayed in the grid. |
ends with |
|
Rows where data in the selected column ends with the entered text string are displayed in the grid. |
does not end with |
|
Rows where data in the selected column does not end with the entered text string are displayed in the grid. |
is N/A |
|
Rows where the selected column contains an N/A value are displayed in the grid. |
is not N/A |
|
Rows where the selected column contains anything other than an N/A value are displayed in the grid. |
is one of |
|
Rows where data in the selected column is identical to any one of the specified
values are displayed in the grid. When selected, this option allows you specify multiple values in the same Value field. For more information, see Specifying a list of values in a selection. |
is not one of |
|
Rows where data in the selected column contains anything other than the
specified values are displayed in the grid. When selected, this option allows you specify multiple values in the same Value field. For more information, see Specifying a list of values in a selection. |
matches |
|
Rows where text matches the specified wildcard pattern are displayed in the
grid. The following wildcard patterns may be used:
|
does not match |
|
Rows where text does not match the specified wildcard pattern are displayed in the grid. |
matches RE |
|
Rows where text matches the specified regular expression are displayed in the grid. |
does not match RE |
|
Rows where text does not match the specified regular expression are displayed in the grid. |