Formula Editor's Tips

Question

In JMP13 formlua editor's tips describe below:

* Pressing Alt (Option on Macintosh) and clicking a column replaces both empty and
non-empty selected fields with that column.
* The right-click menu for the Columns list has two replacement options: Replace all
occurrences of selected subexpression replaces all occurrences of the selected expression
with the currently selected column. Replace the selected subexpression with columns
replaces the selected expression with multiple columns (formerly Shift + Click) for
functions that support it (for example, Sum or Plus).

But I can understand what they mean. Somebody expaln the tips using example.

ih · Accepted Answer

Maybe animations would help?

The alt key:

Replacing all occurrences of a selected expression:

Replacing the selected expression:

txnelson · Accepted Answer

The first tip simply is that if you have a formula

and you hold down the ALT key and then click on one of the columns, the highlighted area in the formula will be filled with the column you clicked on

If the highlighted area is blank as in the above example, it fills in the column.  If the highlighted area already has a value, it replaces it.

The second tip is just an expansion, as to what actions to take on a highlighted area.  In the below example the highlighted area will be filled with all selected columns when you right click on the selected columns, and select "Replace the selected subexpression with columns".  This only works if the element of the function highlighted can handle multiple entries, as the Sum() function from the example handles

The second selection allows for the replacement of multiple entries in a formula, with a single selection.  In the example below, the column "Height" is referenced twice.

By right clicking on a newly selected column, and selecting "Replace all occurrences of selected subexpression"

all elements with the value of "Height" are changed to the newly selected column

I hope these examples help you