topic Undocumented Secrets in Discussions

Undocumented Secrets

hogi — Tue, 07 Oct 2025 23:02:29 GMT

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-From/ev-p/849401 ( @jules )

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

edit: removed in JMP19

please vote:

duplicates:
Please restore ability to copy-paste column names from one table to another

[More Topic Containers like this]

Re: Paste multiple column names

hogi — Tue, 05 Aug 2025 14:58:02 GMT

If you know about and use the function, please comment or vote here.

The function is so hidden and undocumented that it may be deleted in a future version of JMP.

Re: Paste multiple column names

BHarris — Tue, 05 Aug 2025 19:51:11 GMT

Wow, that's cool, I've wanted that many times. Thanks for the tip!

Re: Paste multiple column names

WebDesignesCrow — Thu, 14 Aug 2025 09:00:58 GMT

Wow. Thank you for sharing

Re: Paste multiple column names

BHarris — Tue, 09 Sep 2025 14:03:18 GMT

Now that I know about this, I use it all the time -- copy the column headers out to a text document, change them, then paste them back in. So handy! I *really* hope this feature stays in JMP 19!

Re: Paste multiple column names

hogi — Wed, 01 Oct 2025 18:19:04 GMT

Did you know?
copy/paste via CTRL+C / CTRL-V also works for Value Labels

(view in My Videos)

edit:
in JMP 19, pasting value labels doesn't work via CTRL+V, but via paste from the right click context menu:

Re: Paste multiple column names

BHarris — Wed, 10 Sep 2025 15:43:22 GMT

What are you copying from in this case? Tab-delimited text file perhaps?

Re: Paste multiple column names

hogi — Wed, 10 Sep 2025 15:59:43 GMT

Tab-delimited text works.

A 2

B 3

easiest: get it from a JMP or Excel data table - via CTRL-C.

Then select the empty list box and Press CTRL+V

Re: Paste multiple column names

mikedriscoll — Wed, 10 Sep 2025 20:30:31 GMT

I kind of doubt they would get rid of this function, as it is part of the usefulness of the column pane. Another way I use this is to first select whatever rows I need (either to copy / paste, or maybe tables->subset a subset of rows and columns), and then use the column filter at the top of column pane to filter on and select my subset of columns. Now that my rows and columns are selected, I then hit 'tab' twice to bring focus over to the data pane. Then I can hit ctrl+C (copy data) or ctrl+shift+C (copy data with column names) and then paste them wherever they are going. Or tables->subset if using that feature.

People may not be aware so I'll post the corresponding paste functions:

If pasting to Excel, simple ctrl+V (or regular paste) will work regardless of whether you have previously copied only data or data + columns.

If pasting to a JMP table, ctrl+V will paste the data. ctrl+shift+V will paste the data+column names. Choose based on how you copied the data. It's straightforward if you are pasting into a new / empty table. If you are pasting into a table and have already selected columns and rows in the destination table of where you want the pasted data to go... well, just make sure your row / column selections are 100% correct, and check it after.

Re: Paste multiple column names

hogi — Thu, 11 Sep 2025 15:22:33 GMT

using Tab
nice! - more robust than "clicking somewhere in the data grid"

- and sounds safe against changes in new versions.

-> added to

Re: Paste multiple column names

mikedriscoll — Thu, 11 Sep 2025 17:20:48 GMT

Agreed, and more importantly for the use described above, you don't lose the column and row selections when you tab from pane to pane. If you click in the data grid (after working in the column pane) on to a cell or column header you've lost your previous selection.

Re: Paste multiple column names

hogi — Thu, 25 Sep 2025 19:16:13 GMT

Another helpful secret that got accidentally deleted:

Re: Paste multiple column names

hogi — Sat, 04 Oct 2025 15:03:41 GMT

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

Re: Paste multiple column names

hogi — Thu, 02 Oct 2025 06:16:14 GMT

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

Re: Paste multiple column names

hogi — Thu, 02 Oct 2025 06:11:48 GMT

Re: Paste multiple column names

jcagande — Thu, 02 Oct 2025 06:14:43 GMT

Thanks!

Re: Paste multiple column names

hogi — Wed, 15 Oct 2025 13:34:31 GMT

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)

d) "Paste Multiple"

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

(view in My Videos)

Re: Paste multiple column names

hogi — Wed, 15 Oct 2025 13:59:31 GMT

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)

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

Re: Paste multiple column names

hogi — Thu, 16 Oct 2025 20:02:17 GMT

from: https://community.jmp.com/t5/JMP-Wish-List/Restore-data-grid-behavior-Pasting-onto-column-names-to-rename/idc-p/908079/highlight/true#M7939

Re: Paste multiple column names

hogi — Fri, 17 Oct 2025 15:31:29 GMT

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)