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


Publication date: 06/21/2023

Additional Column Properties

There are three additional properties: Expression Role, Event Handler, and Other.

Expression Role

When you import a column of data that contains image data, the data type is set to Expression to show the data as pictures. Or you can assign the Expression data type in the Column Info window.

To customize how the image looks in the data table cell, or to display matrices and expressions as images, add the Expression Role column property. The default is set to Picture. If the Expression Role is set to Picture and the expression is a picture, then the expression evaluates to a picture and the picture appears in the data table. Otherwise, the expression shows as a JSL expression. Change this setting to alter how expressions are used.

Note: Expression columns that contain images greater than 32KB in size are truncated when saved to Microsoft Excel. Those expression columns are not restored when imported back into JMP.

Select from the following options:

Picture

If the expression contains picture data, the column evaluates and the picture is displayed.

Matrix

If the expression contains a matrix, the column evaluates and the matrix is displayed. Otherwise, the data is displayed as an expression.

Expression

If the expression is simply an expression, use this option to display it in the column.

Use Expression when you want to work with an expression that might contain picture data, but you want to prevent JMP from displaying the image.

Picture expressions

To customize how images appear in a data table cell, select one of the following options after selecting Picture from the list.

maximum width and height

Specifies the maximum width and height of the image in the data table cell.

Stretch

Enlarges a small image to fill the data table cell.

Preserve aspect ratio

Maintains the image’s ratio of width to height in the data table cell. Selected by default.

Add a decorative frame to small images in a data table

Displays a beveled edge around small images in the data table cell.

To drag images into an expression column

1. Create a new column in a data table.

2. Right-click the column, select Column Info, and then select the Expression data type.

3. Right-click the column, select Column Properties, and then select Expression Role.

4. Select options as described above.

5. Navigate to the website that contains the image that you want in your data table. You can also use an image that is on your computer.

6. Select the image, and drag it into an empty cell in the expression column.

Resize the cell to make the image larger.

The SAS Offices.jmp and Big Class Families.jmp sample data tables show an example of an expression column.

Tips:

You can also import data that contains a column of images to create an expression column.

For more information about what you can do with images in an expression column, see Use Images as Markers and Add Images from JMP Data Tables to Hover Labels.

To add an expression column using Summary

1. Select Help > Sample Data Folder and open CrimeData.jmp.

2. Select Tables > Summary.

3. Select State, and click Group.

4. Select Total Rate, and click Statistics > Histogram.

5. Click OK.

A new data table appears that contains a new expression column with images of histograms. Resize the row to make images larger.

For more information about Summary, see Summarize Your Data.

6. Right-click the Histogram(Total Rate) column, and select Column Info.

Notice the column’s data type is set to Expression.

7. Select Expression Role from the Column Properties menu.

The Expression Role is automatically set to Picture. In the rare case that a picture needs to be displayed as an Expression, change the setting to Expression.

8. Click OK.

Expression Role is assigned to the Expression column.

Event Handler

Use the Event Handler column property to define hyperlinks in a text column. The hyperlinks can be used to open web pages and other documents.

Add the Event Handler to a column of URLs to open the URLs in a browser. You can also modify the placeholder scripts on the column property to open different kinds of resources. For example, in a data table of geographical data, you might edit the Click script to display a Google map when the user clicks the hyperlink in the data table. The SAS Offices.jmp sample data table provides examples.

See Add Hyperlinks to Text Columns in the Scripting Guide for more information about editing the scripts.

Other

Use the Other column property to create your own column property and assign it any name that you choose. This property is then available for JSL programming.

1. Right-click the column and select Column Properties > Other.

2. Enter a name for the new property.

3. Enter a value for the property.

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