16.00 - About the Data Filter - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

The Data Filter dialog enables you to set filter rules to define which data is loaded and displayed in the Table Data Editor. Each time you use this dialog, the data is reloaded into the editor based on the rules you specify. To access the Data Filter dialog, click the Filter icon in the Table Data Editor toolbar.

The dialog consists of two tabs described below.

Filter Tab

The Filter tab lists all columns in the table and enables you to set filter rules for each column. It is comprised of the following elements:

List of Columns in Table
The Filter list displays all table columns. Select filter options in Select By to view in the Table Data Editor only data in which you are interested.
Data Type of Column
The Types list shows the column data type.
Selection of Filter Rule
In Select By, create a filter rule to apply to the column. Use the list to select a filter operator and enter a value. For example, you could specify a rule that filters column data for only values greater than 1000. Filter operators are based on column data type.
Filter Rules by Column
The Data Filter dialog provides the ability to define specific filter rules for each column in the selected table. Use this area to define, review, and refine your Table Data Editor view for specific tables. The default is None.
Clear All Button
Click Clear All to reset filter rules for all columns to None.

Sort Tab

Use the Sort tab to specify column row order for the Sort operation. For example, if you move Column3 to the Sort Columns list and position it as the first column in the list, the Sort operation sorts all column rows based on the row order in Column3. The tab consists of the following elements:

List of All Columns in Table
A list of all table columns displays in the Table Columns selection box. You can order the list in either ascending or descending order by table name.
Ordered List of Columns for Sort
Move columns from Table Columns to Sort Columns to specify the column sort order. Use Up and Down to change column order.
Choice Buttons: Order Table Column List
Choose how you want the column list ordered:
  • Ascending - Orders the Table Columns list from the smallest or lowest to the largest or higher value. For example, A to Z or 1 to 100. This is the default.
  • Descending - Orders the Table Columns list from the largest or higher value to the smallest or lowest value. For example, Z to A or 100 to 1.
Action Buttons: Order Columns for Sorting
Move columns up or down in the list. The sort operation uses the column order to determine sorting rules. The primary sort is based on the first column in the list.