Undocumented Secrets

[#1]

hidden secret in JMP: you can paste multiple column names via CTRL+C | CTRL+V

https://community.jmp.com/t5/Abstracts/Plenary-John-Sall-on-Secret-Features-of-JMP/ev-p/849554 @ 44min:

https://community.jmp.com/t5/Abstracts/Advanced-Data-Preparation-10-Essential-Tools-in-JMP-to-Get-Fr... ( @julian )

https://community.jmp.com/t5/Discussions/Possible-to-rename-all-columns-in-a-table-from-a-list/m-p/5...( @txnelson )

edit: removed in JMP19

please vote:

Restore data-grid behavior: Pasting onto column names to rename them 
duplicates:
Please restore ability to copy-paste column names from one table to another 

Restore Column Name Update Via Paste 

[More Topic Containers like this]

[#2]

Another helpful secret that got accidentally deleted:  Restore data-grid behavior: Cmd-Opt-Click (or Ctrl-Alt-Click) to select intersections of rows 

[#3]

@BHarris  submitted wishes to restore the paste column names functionality:

Restore data-grid behavior: Pasting onto column names to rename them 

[#4]

https://community.jmp.com/t5/JMPer-Cable/New-in-Graph-Builder-for-JMP-19/bc-p/904473/highlight/true#... 
 Order by() with nested axes in JMP 19:

options for "order by" in Graph Builder 

[#5]

Match count not showing in the Join Table Preview in JMP 19 

[#6]

Thanks!

[#7]

 replacing column names via CTRL+V doesn't work anymore in JMP19

.... but there is a workaround:
a) select columns to rename

b) copy new column names to clipboard

c) Recode Column Names- Only selected columns 

d) "Paste Multiple"

JMP19 (c+d): 7 mouse clicks  -  instead of CTRL+V in JMP18

[#8]

As an alternative, you can link a script to a Keystroke - or run it via the main menu (with 2-3 mouse clicks):

View more...

names default to here(1);
dt = current data table();

cols = dt << get selected columns();
oldColNames = Transform each({col}, cols, col << get name);
newColNames = Words(get clipboard(),"\!n\!t,;");
set clipboard(concat items(oldColNames, "\!t")); // poor man's CTRL + Z 

if(!(nitems(newColNames)==nitems(oldColNames)),
	Caption("# colnames doesn't match");
);

for each(  {col,idx}, cols, col << set name(newColNames[idx]));

Caption (Char(N items(newColNames))  || " column names replaced");
wait(1);
Caption(remove);

[#9]

from: https://community.jmp.com/t5/JMP-Wish-List/Restore-data-grid-behavior-Pasting-onto-column-names-to-r... 

[#10]

Another hidden functionality: edit table scripts by double click

JMP18:
- in the Table Scripts menu, one can double click on a script to open end edit the script
- to change the name of the script,  select it and click again

this is similar to Windows Explorer [sorry, difficult to distinguish Click and double click in the video - just try on your own ...]

JMP 19:
- click + click again: not working anymore
- double click: change the name of the script
- edit the script: only accessible via right click menu : (

I just asked JMP support [TS- ?   ] if the change was intentional ...

[#11]

Columns are evaluated?
check the status bar of the window in front - when JMP is finished, it says : evaluations done

in JMP19, such calculations are secret, JMP is saying "evaluations done" - but evaluations are running in the background.

With a little trick, you can actually get JMP to reveal its secret recalculations:

dt = Current Data Table();
cols = dt << get column references();


Eval(
	Eval Expr(
		New Column( "recalc",
			Formula(
				If( Row() == 1,
					Sum(
						Transform Each( {col}, Expr( Name Expr( cols ) ),
							Is Missing( col[Row()] )
						)
					);
					Caption( "recalc" );
					Wait( 0 );
				)
			)
		)
	)
);