In the table viewer,
you can right-click a column heading to filter and sort the data by
that column.
The filter options vary
depending on the type of column that you have selected. The
Add
Filter window for a numeric column enables you to specify
one or two filter criteria for each column. To add a second filter
criterion, click
![Add to filter button](images/add.png)
.
The
Add
Filter window for a character column enables you to select
one or more values in the column.
The
Add
Filter window for a date column enables you to select
a date value from a pop-up calendar window.
When you create a filter
on your data, the filter criteria are displayed at the top of the
workspace. You can click
![Filter table rows button](images/filter.png)
to edit the filter and
![Clear filter button](images/clear.png)
to delete the filter.