Work with Columns

This section covers JSL actions that you can perform on columns in a data table, such as creating, grouping, and setting and getting attributes and properties.

• Send Messages to Data Column Objects

• Create Columns

• Create a New Column by Text Matching

• Add Several Columns at Once

• Group Columns

• Use Set Selected to Select Columns

• Rearrange and Move Columns

• Recode Columns

• Add a Column Switcher

• Compress Selected Columns

• Create Custom Functions, Transforms, and Formats

• Custom Transform Example

• Delete Columns

• Get Column Names

• Set or Get Column Attributes

• Set or Get Column Properties

Note: JMP can display math symbols and Greek letters (controlled in Preferences in the Font category). This means that if you save a column (such as T square limits), the column name could either be “T Square Limits” (no special characters) or “T2 Limits” (with special characters). Any reference using the column name must match the name exactly, or it fails.

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