Show/Hide Columns Function

 

The Show/Hide Columns function is used to select the columns that should be displayed in the table.  Select the Show/Hide Columns (Show/hide columns button) toolbar button in the Data Table Window to present the Show/Hide Columns window:  

Show/Hide Columns screen shot

The table at the top of the window lists all of the column names and whether or not the columns should be shown.  A check beneath the "Show?" column heading indicates that a given column will be displayed.  You may directly check and un-check the check boxes by clicking on them with the mouse.  The vertical scroll bar on the right is used to move up and down through the table of column names.

Highlight rows and then click Select to select column headings.

Click Invert to automatically de-select the blue rows and select those that were white.

Click the Show or Hide buttons to change all of the selected check boxes under the "Show?" column.  

You may also choose to show or hide columns whose names meet certain criteria:

  1. First specify whether or not to select columns on all or any of the criteria to be specified (not important if only a single criterion will be used).  Click the Match using: ALL criteria or ANY criteria radio button to reflect whether the filter should be set for this "And" or "Or" condition.

  2. Click the Add Criteria button to add a row to the table below the Column Name, Operation, and Value columns.  Each row represents a filter condition that filters the list of column names.  Click the Delete Criteria button to remove any criteria that are selected (shown in blue).  To select a single criterion, click the mouse on any entry in that row.  To select multiple criteria (in an MS-Windows operating system), hold the control key down while clicking the mouse.

  3. On this screen the Column Name column is always called "Column Name."  This indicates that the criterion will reflect a characteristic of the column name.  Click the mouse on the second cell in the first white or blue row of the table (under the  Operation column), and a pull-down menu  appears.  The menu shows a list of operations that apply to numeric, logical, and string variables (>, <, >=, <=, =, not =, starts with, does not start with, contains, does not contain, ends with, and does not end with); choose the one to use for selecting a group of columns.  Complete the selection statement by typing directly into the cell in the Value column.

  4. Then click the Select button to highlight in blue those rows whose column names match the criteria.  Click the Show or Hide buttons to change all of the selected check boxes under the "Show?" column. 

Click OK to reduce the number of columns on the Data Table Window to include only the ones selected to be shown and close the Show/Hide Columns window.  

Click Cancel to close the Show/Hide Columns window without making any changes.  

Click the Reset  (Reset button) toolbar button on the Data Table Window to return the display to show all of the columns.