Reference Columns and Table Variables | JMP 12

JMP Support 800.450.0135 (US)

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

Using JMP • Formula Editor • Reference Columns and Table Variables

•

Reference Columns and Table Variables

You can create a formula that refers to values found in other parts of the data table, such as other columns and table variables.

When a formula uses values in other columns, the values in the column with that formula are dependent on the values in those other columns. Whenever a column that the formula refers to changes, the dependent column also changes. If you delete the referenced column, empty terms appear in the column containing the formula.

If you create a formula that refers to values found in table variables, those table variables must already exist in the data table. Table variables are character strings that are available to the entire table. Their names are displayed in the table panel at the left of the data table. (For details, see Use Table Variables in Enter and Edit Data.)

To build a formula that references values found in columns or table variables

1.	Open the Formula Editor by right-clicking a column name in the data table and selecting Formula.

2.	Select a box in the formula editing area by clicking it. (It is selected when there is a red outline around it.)

3.	Click the menu on the formula element browser and select either Table Columns or Table Variables. Highlight an element from that category’s list. The element is added to the selected box in the formula editing area.

For an example of referencing a column in a formula, see Use Basic Formula Editor Features.

Note: In a formula, when you reference a column using value labels, hover your mouse over the value label to see the actual data value.