Filtering the Answerset - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Filtering the Answerset

You can filter by multiple columns, where each filter is applied to the currently displayed rows only.

1 Click on the Answerset column header.

A drop down window appears.

2 Do one of the following:

  • Click on the check boxes next to the list of column values to include or exclude rows that contain that column value. For dates and timestamps, the list is replaced by a Tree that allows you to select at the year, month, day level.
  • Click Number filters, then select a condition from the displayed sub menu. In most cases, a dialog into which you can enter a value for the condition appears.
  • Click Text filters, then select a condition from the displayed sub menu. In most cases, a dialog into which you can enter a value for the condition appears.
  • Click Date filters then select a condition from the displayed sub menu. In some cases, a dialog into which you can enter a value for the condition appears.
  • Click Filter by Color then click one of the listed colors to display only those rows that use that background color in this column.
  • Click Clear filter from ‘xxx’ to remove any existing filter from this column. The type of filter displayed (Number, Date or Text) will depend on the data type of the column.
  • Note: Use Find instead of filtering a large spreadsheet by a unique column.