Filtering in a table column

TIP: You might want to count the occurrences of a value before filtering it. See Counting occurrences of unique values in a column for information about counting the number of times a value appears in a column. You can continue using the Profile modal window to filter. For information about the Profile modal window, see Filtering by using the Profile window.

You can filter a table column in one of two ways:

  • Select values in a table column and use a table cell option to include or exclude them in the resultant table.
  • Use a column drop-down menu item to specify conditions for filtering values in the column.

Filtering based on values selectable in a column

If you want to filter based on one or multiple values in a column, follow these steps:

  1. Right click a cell containing a value that you want to filter (or exclude). The cell options are displayed.

    To select multiple values, use your computer's key combination (for example, Ctrl-Shift) when clicking additional cells.

    The value or values you select can be in any row. For example, to filter the value 10, click any cell containing 10 in the column. The result is the same regardless of the row number of the selected.

  2. To include the selected value, click Filter this value; to exclude the selected values, click Exclude this value. (If multiple values are selected, the options are Filter these values and Exclude these values.)

The following screenshot shows the cell options in the DayofMonth_integer column and the cells containing values that you can include or exclude.

Filtering based on a condition

You can filter based on a condition. For example, for a selected column, you can filter depending on whether the string contains a particular substring.

You can also filter based on multiple conditions. For information about filtering on multiple conditions, see Filtering based on multiple conditions.

To filter based on a condition, follow these steps:

  1. Right click the heading of the column containing the value to filter. A drop-down menu appears.
  2. Select Filter... from the menu. The FILTER panel appears.

  3. Select the filter function. For example, for a column of data type Integer or Float, you can select the between function to filter values that exist between two values.

    NOTE: If you select a filter function that is not applicable to the data type of the column, an error message is displayed. For example, if the data type of the Distance column is String, and you try to run the gt (greater than) function on the column, an error message is displayed. You can change the data type in the Cast field to either Integer or Float, which enables the function to run properly. However, this data type change is temporary. The column (the Distance column) remains as a String column.
  4. Based on the description of the function, fill out the fields.
  5. Click FILTER.

Filtering based on multiple conditions

You can specify multiple conditions for filtering. You must choose the operator for connecting the conditions as described in this list:

  • The AND operator means that all specified conditions must be true for a row to be included in the resultant table.
  • The OR operator means that only one of the specified conditions must be true for a row to be included in the resultant table.

Follow these steps to filter based on multiple conditions:

  1. Follow the instructions in Filtering based on a condition to specify the first condition.
  2. Click for Additional Conditions.
  3. Select a filter function and fill out the fields as you do for the first condition.
  4. Repeat steps 2 and 3 for each additional function.
  5. Select the operator to connect the conditions.
  6. Click FILTER.

Example of filtering values that meet all conditions

You can specify as many conditions as you want. This example illustrates how to apply the AND operator to two functions.

In the table named mail2, you can specify these conditions:

  • The value in the lineNumber column is between 50 and 80 (inclusive).
  • The value in the From column contains the substring Keith.

Select the AND operator in the FILTER panel to indicate that a row must meet both conditions to be included in the resultant table. The following screenshots illustrate how to enter information in the FILTER panel to specify the conditions.

The following partial screenshot illustrates the resultant table, which includes only rows that meet both specified conditions.

Example of filtering values that meet one of multiple conditions

You can specify as many conditions as you want. The example in this section illustrates how to apply the OR operator to two functions.

In the table named mail2, you can specify these conditions:

  • The value in the lineNumber column is between 50 and 60 (inclusive).
  • The value in the lineNumber column is between 70 and 80 (inclusive).

Select the OR operator in the FILTER panel to indicate that a row must meet one of the specified conditions to be included in the resultant table. The following screenshots illustrate how to enter information in the FILTER panel to specify the conditions.

The following partial screenshot illustrates the resultant table, which includes only rows that meet one of the specified conditions.

Go to top