cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hogi
Level XIII

Undocumented Secrets

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:

(view in My Videos)

 

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

 

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]

28 REPLIES 28
hogi
Level XIII

Re: Paste multiple column names

hogi
Level XIII

Re: Paste multiple column names

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

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

 

hogi
Level XIII

Re: Paste multiple column names

hogi
Level XIII

Re: Paste multiple column names

jcagande
Level II

Re: Paste multiple column names

Thanks!

hogi
Level XIII

Re: Paste multiple column names

 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

 

(view in My Videos)

 

hogi
Level XIII

Re: Paste multiple column names

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

(view in My Videos)

 

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);
hogi
Level XIII

Re: Paste multiple column names

hogi
Level XIII

Re: Paste multiple column names

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

(view in My Videos)

 




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

(view in My Videos)

 





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 ...

(view in My Videos)

 



hogi
Level XIII

Re: Paste multiple column names

Another removed function:

Are Column formulas being evaluated?
check the status bar of the window in front - when JMP is finished, it says : evaluations done

(view in My Videos)



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 );
				)
			)
		)
	)
);

(view in My Videos)

 

Recommended Articles