Data Grid | JMP 13.2

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Get Started • Data Tables • Data Grid

•

The data grid is the main part of the data table that contains your data. Interacting with the Data Grid illustrates how to interact with the data grid. See also Select Rows in Enter and Edit Data.

Interacting with the Data Grid

No.	Description
1	Hides or shows the data table panels.
2	Click to deselect any selected columns. To select all columns, hold down the Shift key and click. Double-click to add multiple columns.
3	Shows the columns menu.
4	Click to select the column. Double-click to view the Column Info window. See About the Column Info Window. Right-click for column options. See Pop-Up Menu for Columns.
5	Double-click the column name to edit it in the Column Info window, or select the column name and press Enter.
6	Click and drag to adjust the width of the column. To simultaneously adjust the widths of all of the selected columns, hold down the Alt key as you click and drag.
7	Click to select the row. Double-click to open the Row Editor. See Use the Row Editor to Edit Cells in a Row in Enter and Edit Data. Right-click for row options. See Pop-Up Menu for Rows.
8	Shows the rows menu.
9	Click to deselect all selected rows. To select all rows, hold down the Shift key and click. Double-click to add rows.

Pop-Up Menu for Columns

Right-clicking in a column heading shows these options:

Opens the Column Info window. See About the Column Info Window.

Column Properties

Contains a list of column properties. Select one to open the Column Info window and apply it to the column. This list is also available from the Column Info window. See Column Properties in The Column Info Window.

Opens the Formula Editor. See the Formula Editor topic.

New Formula Column

Creates a formula column. See Make a New Formula Column in Enter and Edit Data for details.

Inserts one or more columns before the selected column or columns.

Deletes all selected columns.

Labels or unlabels selected columns in all plots. See Label Rows and Columns in Enter and Edit Data.

Used in virtually joined data tables to mark a column in the auxiliary data table as the ID column. That is, the rows of the data table are uniquely identified by the values of the ID column. The Link ID column property checkbox is selected if the column is the ID column for the data table. See Virtual Join Properties in The Column Info Window for details.

Used in virtually joined data tables to map a column in the main data table to the ID column in the auxiliary data table. The Link Reference column property specifies the path name of the auxiliary data table. See Virtual Join Properties in The Column Info Window for details.

Sorts all of the rows in the table by the values in the selected column. You can choose to sort the rows in ascending or descending order. See Sort Data Tables in Reshape Data.

Copy Column Properties

Copies all of the column properties for the selected column. Note that if you copy column properties for more than one column and then paste into a single column, all column properties are pasted into that single column.

Paste Column Properties

Pastes all of the copied column properties into the selected column or columns.

Copy Multi Columns Properties

Copies all of the column properties for the selected columns. Supports adjacent and non-adjacent columns.

Paste Multi Columns Properties

Pastes all of the copied column properties into the selected adjacent or non-adjacent columns. For example, select column one and column two and then select Copy Multi Column Properties. Select column three and column five and then select Paste Multi Column Properties. Column one properties are pasted into column three. Column two properties are pasted into column five.

Pop-Up Menu for Rows

Right-clicking in a row heading shows these options:

Hide and Exclude

Hides the selected rows in all plots and graphs and excludes them from analyses. See Hide and Exclude Rows in Enter and Edit Data.

Exclude/Unexclude

Excludes or includes selected rows from analyses. See Exclude Rows in Enter and Edit Data.

Hides or shows selected rows in all plots and graphs. See Hide Rows in Enter and Edit Data.

Labels or unlabels selected rows in all plots. See Label Rows and Columns in Enter and Edit Data.

Provides a color palette. Select a color to apply it to the selected rows. The color is used in plots and graphs. See Assign a Color to Rows in Enter and Edit Data.

Provides a palette of markers or symbols. Select a marker to apply it to the selected rows. The marker is used in plots and graphs instead of points. See Add Markers to Rows in Enter and Edit Data.

Color Rows by Row State

Colors the row the same as the current row state color. For more details, see Assign Colors or Markers to Rows Based on Column Values in Enter and Edit Data.

Select Matching Cells

Selects rows in the active data table with values that match the selected row(s). See Select Cells in Enter and Edit Data

Invert Selection

Selects all previously deselected rows, and deselects all currently selected rows.

Clear Row States

Clears all active row states in the data table. All rows become included, visible, unlabeled, and show in plots as black dots. It does not affect row states saved in row state columns. See Delete Row Characteristics in Enter and Edit Data.

Adds the specified number of rows to the data table. See Add Rows in Enter and Edit Data.

Removes all selected rows from the data table. Use the Undo command on the Edit menu to undo an accidental deletion. See Delete Rows and Columns in Enter and Edit Data.

The cursor takes different forms, depending on its location in the data grid.

The standard arrow cursor appears in the following locations:

–

In the panels area to the left of the data table

–

In the triangular rows and columns area, located in the upper left corner of the data grid

–

In the middle or bottom of a column heading

You can perform the following actions with the arrow cursor:

–

To select a column using the arrow cursor, click its name in the Columns panel.

–

Double-click a column name in the Columns panel to edit it. Or, in the column heading, double-click on the column name to edit it.

–

Click the triangular areas in the upper left corner of the data grid to deselect rows and columns.

Selection (Large Plus) Cursor

When the cursor is at the top of a column heading, or in a row number area, it becomes a large plus, indicating that you can select rows or columns. When you click, that row or column is selected and highlighted. Click and drag to select multiple rows or columns, and hold down the Control key and click to select discontiguous rows or columns.

–

Double-click a column heading area to see the Column Info window for that column.

–

Select a column to change the column name. The column highlights. Begin typing (if it is not in a locked column or locked data table).

–

Double-click the row number area to edit the rows using the Row Editor.

When you select editable text, the cursor becomes a standard I-beam. To edit text, position the I‑beam within highlighted text. Click to mark an insertion point, or drag to select text for replacement.

Double Arrow Cursor

The cursor changes to a double arrow when it is on a column or a panel boundary. Drag this cursor left or right to change the width of a column or panel. Changing the width of a column does not affect the column field width specified in the Column Info window (accessed by double-clicking a column name).

Tip: You can adjust widths of all selected columns at once by pressing the Alt key as you drag the double arrow cursor on any of the selected column boundaries.

List Check Cursor

The cursor changes form when you move the mouse over values in columns that have data validation in effect. It becomes a small, downward-pointing arrow on a column with list checking. When you click, the value is highlighted and the cursor becomes the I-beam. Enter or edit data as usual with any values defined as valid text or valid numbers. See List Check in The Column Info Window, for details.

The cursor changes to a pointer over these objects:

–

Red triangle menus for options

–

Triangular disclosure buttons

that open or close panels

–

Data table titles for editing

–

Table script titles for opening

–

Modeling type icons for changing

•

Help created on 9/19/2017