Using JMP • Get Started • Data Tables • Data Table Panels

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

Previous
 • 
Next
Data Table Panels
Data tables contain three panels:
•
Table panel
•
Columns panel
•
Rows panel
These panels are located on the left of the data grid. They contain information about the table and its contents. Each panel has interactive areas. See Figure 2.4.
Figure 2.4 Interacting with the Data Table Panels
Table Panel
The Table panel contains the following elements:
•
Name of the data table
•
Icons indicating the table state
•
Red triangle menus containing table and script options
•
(Optional) Table variables
•
(Optional) Table scripts
Figure 2.5 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 Data topic.
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 Table Variables in Enter and Edit Data for more information.
Note: To rename a table variable, double-click on 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 Enter and Edit Data.
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 Tables in Enter and Edit Data.
Compress file when saved
Compresses the data table when it is saved. After the data table is saved, a compressed file icon appears next to the data table name in the table panel. See Compress Tables in Enter and Edit Data.
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 Enter and Edit Data.
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.
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 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 holding down the Control key, 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.
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
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 list of columns found in the data table
•
Icons indicating each column’s modeling type (see About Modeling Types in The Column Info Window)
•
Icons representing characteristics and properties assigned to the columns (not shown, see Figure 2.7)
Figure 2.6 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
Note: Italics indicate that the column is locked into place. When you scroll horizontally, the column remains visible.
Icons that can appear in the Columns panel are described as follows:
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 in Enter and Edit Data.
Image shown here Indicates that the column is excluded from the calculations. See Exclude Rows in Enter and Edit Data.
Image shown here Indicates that the column is not included in graphs. See Hide Rows in Enter and Edit Data.
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 in The Column Info Window.
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 Use Formula Editor Options in Formula Editor.
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 in The Column Info Window and List Check in The Column Info Window.
Image shown here Indicates that the column has been assigned the preselected role of weight. See Assign a Preselected Analysis Role in The Column Info Window.
Image shown here Indicates that the column has been assigned the preselected role of frequency. See Assign a Preselected Analysis Role in The Column Info Window.
Indicates that the column values cannot be edited. See About the Column Info Window in The Column Info Window.
Indicates that the expression column contains images that can be used as markers. See Use Images as Markers in JMP Reports for details.
Virtual Join Icons
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.
Indicates that the column has a Link Reference column property. Gray indicates that the referenced data table is not open or not linked properly.
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.
Indicates that the column is linked from the referenced data table.
For details about virtual join, see Virtually Join Data Tables in Reshape Data.
Rows Panel
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
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
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.

Previous
 • 
Next
Help created on 3/19/2020