16.20 - Grouping 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
Teradata SQL Assistant can display data rows in the Answerset window in a grouped, sorted order.
  1. In the active window, click .
    A Group Bar appears above the spreadsheet.
  2. Drag the column header you want to group by to the Group Bar.

    If you group by a single column, each row in that column displays the column name followed by the column value and the number of rows that have this value in parentheses. To open a group, click on the + symbol at the left of the row.



  3. To group by multiple columns, drag the additional column headers to the right of the previous ones on the group bar.

    They are connected in descending order.

    The top-level group continues to display the column name and data value, but does not display the number of rows that contain that value. The lower-level Group rows display the column number (starting at column zero) followed by the data value for that group. Each header you drag to the Group Bar display a Sort icon to indicate the current sort direction. You can reverse the direction by clicking on this icon.



  4. To ungroup the rows, drag the headers back to the spreadsheet header bar, or simply click a second time.