Formula Editor's Tips

[#1]

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.

[#2 · Accepted solution]

Maybe animations would help?

The alt key:

Replacing all occurrences of a selected expression:

Replacing the selected expression:

[#3]

Thanks a lot.

[#4 · Accepted solution]

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 

[#5]

Thnaks,

The reason I asked that why use ALT key instead of double clicking so I wish it maybe another useful fuction but nothing.

second tip would be useful when several variables should be replaced at one time.