cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
24 REPLIES 24
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

 

 

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

 




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

 



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



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

 

Recommended Articles