16.20 - Filtering the Answerset - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
You can filter by multiple columns, where each filter is applied to the currently displayed rows only.
Use Find instead of filtering a large spreadsheet by a unique column.
  1. Click on the Answerset column header.
  2. In the drop-down window, do one of the following:
    • Select the checkboxes 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) depends on the data type of the column.