Choose Language Hide Translation Bar
JONGSEON
Community Trekker

Formula Editor's Tips

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.

0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
ih
ih
Community Trekker

Re: Formula Editor's Tips

Maybe animations would help?

 

The alt key:

Alt.gif

 

 

Replacing all occurrences of a selected expression:

All Occurrences.gif

 

 

Replacing the selected expression:

Selected.gif

View solution in original post

txnelson
Super User

Re: Formula Editor's Tips

The first tip simply is that if you have a formula

formula1.PNG

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

formula2.PNG

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.

formula3.PNG

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

formula4.PNG

 

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. 

formula6.PNG

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

formula7.PNGall elements with the value of "Height" are changed to the newly selected column

formula8.PNGI hope these examples help you 

 

 

 

Jim

View solution in original post

4 REPLIES 4
ih
ih
Community Trekker

Re: Formula Editor's Tips

Maybe animations would help?

 

The alt key:

Alt.gif

 

 

Replacing all occurrences of a selected expression:

All Occurrences.gif

 

 

Replacing the selected expression:

Selected.gif

View solution in original post

JONGSEON
Community Trekker

Re: Formula Editor's Tips

Thanks a lot.

 

0 Kudos
txnelson
Super User

Re: Formula Editor's Tips

The first tip simply is that if you have a formula

formula1.PNG

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

formula2.PNG

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.

formula3.PNG

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

formula4.PNG

 

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. 

formula6.PNG

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

formula7.PNGall elements with the value of "Height" are changed to the newly selected column

formula8.PNGI hope these examples help you 

 

 

 

Jim

View solution in original post

Highlighted
JONGSEON
Community Trekker

Re: Formula Editor's Tips

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.

0 Kudos