For the latest version of JMP Help, visit JMP.com/help.


Publication date: 06/21/2023

Data Table Panels

In JMP data tables, the Table, Columns, and Rows panels contain information about the data table and its contents.These interactive panels are located on the left of the data grid.

Figure 2.4 Interacting with the Data Table Panels 

Interacting with the Data Table Panels

Table Panel in Data Tables

The Table panel contains the following elements:

Name of the data table

Icons indicating the table state

Red triangle menus containing table options

(Optional) Table variables

(Optional) Green triangles for table scripts

Figure 2.5 Example of a Table Panel 

Example of a Table Panel

Table Options

Clicking on the red triangle menu next to the data table name shows these options:

Tables

Contains the same options as the Tables menu. See Reshape Your Data.

New Table Variable

Creates a new table variable, which can be text or any other constant character value that you always want to be available in the data table. Table variables are normally used to document tables. See Use Data Table Variables.

Note: To rename a table variable, double-click it and enter a new name in the Name field.

New Script

Creates a JSL script to save with the data table. After selecting this command, name the script and type in the value (the JSL commands). After you click OK, the new script is listed in the Table panel and you can click its green triangle to run, edit, or delete it. See Create and Save Scripts in Data Tables.

Group Scripts

Moves the selected scripts into a group. Click the group name to rename it. Helpful when you want to organize scripts or minimize a long list of scripts.

Ungroup Scripts

Ungroups scripts in the selected group to return them to the top level.

Suppress Formula Eval

Turns off the feature that automatically evaluates formulas. You can turn off evaluation and build sections of a formula. To then test the formula, deselect Suppress Formula Eval.

Lock Data Table

Locks the data table so that data and column properties cannot be edited or added. You can still run analyses and assign characteristics. See Lock Data Tables.

Compress file when saved

Compresses the data table when it is saved. After the data table is saved, a compressed file icon Image shown here appears next to the data table name in the table panel. See Compress Data Tables.

The Compress file when saved option only decreases the file size. This command does not affect the memory required to analyze the data. To reduce both the file size and memory required for analyzing, use Cols > Utilities > Compress Selected Columns. See Compress Selected Columns in Data Tables.

Tip: You can also configure JMP to always use GZ compression when saving tables by selecting Preferences > General > Save Data Table Columns GZ Compressed.

Disable Undo

Removes all actions from the undo history and does not record future actions. Undos are disabled only while the data table is open; the setting is not saved with the data table. This option saves memory, especially when you delete many rows or perform other tasks on the data table that require a large amount of memory to record the data.

Copy Table Script

Copies the script that re-creates the table. To re-create the table, put the copied script in a new script and run it. Note that referenced columns in virtually joined tables are not included in the script.

Copy Table Script (No Data)

Copies the script that re-creates the table but omits the data.

Rerun Formulas

Re-evaluates all columns containing formulas within the data table.

Script Options

To run a script from the data table panel, click the green triangle Image shown here next to the script name. Right-clicking the script name or green triangle shows these options:

Run Script

Runs the script.

Tip: Run multiple table scripts at once by pressing Ctrl while selecting the table scripts you want to run. Then, right-click inside the empty area under the list of table scripts, and select Run Script.

Edit

Opens most scripts in the script editor so that you can edit it. Opens a JMP application script in Application Builder.

Edit with Recode

Opens a recode script (which you created by recoding a column and saving the script) in the script editor.

Delete

Deletes the script.

Group Scripts

Moves the selected scripts into a group. Click the group name to rename it. Helpful when you want to organize scripts or minimize a long list of scripts.

Ungroup Scripts

Ungroups scripts in the selected group to return them to the top level.

Copy

Copies the script. You can then paste it into the Table panel of another data table.

Debug Script

Opens the script in the JSL Debugger. See Debug or Profile Scripts in the Scripting Guide.

Paste

Pastes the script from another data table.

Additional Options

In the Table panel, you can also perform the following tasks:

Double-click a table variable or script name to edit the name and content.

Drag a table variable or script to rearrange it.

Columns Panel in Data Tables

The Columns panel provides a way to view and move columns. The panel contains the following information:

Column options (contains some of the same options as the Cols menu)

Total number of columns and number of columns selected in the data table

A filter box to help you quickly find columns (click the magnifying glass icon to set search filter options and parameters)

A list of columns found in the data table

Icons indicating each column’s modeling type (see About Modeling Types)

Icons representing characteristics and properties assigned to the columns (not shown, see Figure 2.7)

Figure 2.6 Example of a Columns Panel 

Example of a Columns Panel

Icons Representing Column Characteristics and Properties

Icons to the right of each column name indicate characteristics and properties the columns contain.

Figure 2.7 Icons Indicating Column Characteristics and Properties 

Icons Indicating Column Characteristics and Properties

Note: Italics indicate that the column is locked into place. When you scroll horizontally, the column remains visible.

Here are the icons that can appear in the Columns panel:

Image shown here Indicates that points on plots corresponding to the column are labeled by the value instead of the row number. See Label Rows and Columns.

Image shown here Indicates that the column is excluded from the calculations. See Exclude Rows in Data Tables.

Image shown here Indicates that the column is not included in graphs. See Hide Rows in Data Tables.

Image shown here Can be X or Y. Indicates that the column has been assigned the preselected role of x or y. See Assign a Preselected Analysis Role to a Column.

Image shown here Indicates that the column has been assigned the preselected role of validation. See Assign a Preselected Analysis Role to a Column.

Image shown here Indicates that the column contains one or more properties. Click to reveal a list of properties the column contains.

Image shown here Indicates that the values in the column result from a formula. When formula evaluation is suppressed, the icon appears gray. Double-click to view and edit the formula. See JMP Formula Editor Options.

Image shown here Indicates that the range check or the list check option is turned on. Click to view and edit the range or list. See Range Check and List Check.

Image shown here Indicates that the column has been assigned the preselected role of weight. See Assign a Preselected Analysis Role to a Column.

Image shown here Indicates that the column has been assigned the preselected role of frequency. See Assign a Preselected Analysis Role to a Column.

Image shown here Indicates that the column values cannot be edited. See About the Column Info Window.

Image shown here Indicates that the expression column contains images that can be used as markers. See Use Images as Markers.

Virtual Join Icons

Image shown here Indicates that the column has a Link Reference column property. This property links a column in the current data table to the ID column in the referenced data table. Blue indicates that the referenced data table is linked.

Image shown here Indicates that the column has a Link Reference column property. Gray indicates that the referenced data table is not open or not linked properly.

Image shown here Indicates that the column has a Link ID column property, which marks a column in the data table as the ID column. That is, the rows of the data table are uniquely identified by the values of the ID column.

Image shown here Indicates that the column is linked from the referenced data table.

For more information about virtual join, see Virtually Join Data Tables.

Search Filter Options

To show search filter options in the columns list, select Show Filter from the columns list’s red triangle menu. This enables you to customize your search for columns, which is particularly helpful with long lists of columns.

Click the down arrow button next to the search box to refine your search.

Contains Terms

Returns items that contain a part of the search criteria. A search for “ease oom” returns messages such as “Release Zoom”.

Contains Phrase

Returns items that contain the exact search criteria. A search for “text box” returns entries that contain “text” followed directly by “box” (for example, “Context Box” and “Text Box”).

Starts With Phrase

Returns items that start with the search criteria.

Ends With Phrase

Returns items that end with the search criteria.

Whole Phrase

Returns items that consist of the entire string. A search for “text box” returns entries that contain only “text box”.

Regular Expression

Enables you to use the wildcard (*) and period (.) in the search box. Searching for “get.*name” looks for items that contain “get” followed by one or more words. It returns “Get Color Theme Names”, “Get Name Info”, and “Get Effect Names”, and so on.

Invert Result

Returns items that do not match the search criteria.

Match All Terms

Returns items that contain both strings. A search for “t test” returns elements that contain either or both of the search strings: “Pat Test”, “Shortest Edit Script” and “Paired t test”.

Ignore Case

Ignores the case in the search criteria.

Match Whole Words

Returns items that contain each word in the string based on the Match All Terms setting. If you search for “data filter”, and Match All Terms is selected, entries that contain both “data” and “filter” are returned.

Rows Panel in Data Tables

The Rows panel contains the following information:

Row options (same options as the Rows menu)

Total number of rows

Number of selected (highlighted), excluded, hidden, and labeled rows

Figure 2.8 Example of a Rows Panel 

Example of a Rows Panel

Right-click the categories in the Rows panel to select rows, clear the selection, or to create a data view.

A data view creates a linked subset of the main data table. For example, if several rows are marked hidden, you might want to open a window that shows you only the hidden rows. Right-click Hidden in the Rows panel and select Data View.

Figure 2.9 Creating a Data View from the Rows Panel 

Creating a Data View from the Rows Panel

When using a data view, continue to do most of your editing in the main data table. When you make changes in either the main data table or in the data view, the changes are reflected in both. You can make minor changes (such as changing some data or adding a column) in the data view. However, if you want to make major changes (like adding a formula) you must make those changes in the main data table.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).