cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

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

What inspired this wish list request? In pre-JMP 18 versions, selecting one or more column names in the Columns pane and pasting lines from the clipboard would rename the selected columns based on the pasted text — typically separated by tabs or line breaks. In JMP 19, this no longer works. Pasting appears to be ignored, and does not affect the selected columns. Example use case: I have a text file with 10 new variable names and a JMP table with 10 unnamed columns. I used to be able to copy the names from the text file, select the 10 column headers in JMP's Columns pane, and paste — instantly renaming them. This was a powerful and elegant workflow for organizing data.

 

What is the improvement you would like to see? Please restore the ability to paste names directly onto selected column names to rename them. This used to be a very helpful feature and enabled fast bulk renaming, saving time and avoiding human error when copying names individually.

 

 

Why is this idea important? It allows quick, accurate batch renaming of columns without repetitive manual entry, saving time and reducing user error.

 

 

5 Comments
hogi
Level XIII

marked as removed in CTRL/Alt/Shift + click/select/double click/right click 

@Sarah-Sylvestre could you please check if the absence of the functionality in JMP19 is considered a bug.
if it's no bug: how many kudos do we have to collect to get it implemented again? any chance that it will comeback in JMP19.0.1 ?

 

all the eastereggs in JMP are great. But if a function is not documented at all, there is a significant risk that it gets deleted accidentally:

Undocumented Secrets 

 

duplicates of this wish:
Restore Column Name Update Via Paste 

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

shampton82
Level VII

@BHarris 

Oh man, if that went away that is horrible, I use that all the time!!  I kudo'd for support.

hogi
Level XIII
hogi
Level XIII

workaround in JMP19:
https://community.jmp.com/t5/Discussions/Undocumented-Secrets/m-p/907814/highlight/true#M106606 

7 mouse clicks instead of (CTRL+V)
-> acceptable till JMP 19.1?


Status changed to: Yes, Stay Tuned!

We're excited to share that this functionality will be available in JMP 19.1. It will work just like it did in JMP 18, with one small change: when you paste column names, a "Recode - Column Names" pop-up menu will appear. You can choose to interact with it or simply click Recode —either way, the core functionality remains the same.

I will also share some information from one of our developers on how you can currently accomplish this in JMP: 

There are several ways to address this after your data is in JMP. However, it should be faster (and with better handling of column data and modeling types) to use import tools:

  • Use "Paste With Column Names" under the JMP Data Table "Edit" menu.
  • Excel-specific
    • Use the JMP Excel Add-in in the Excel ribbon to transfer your selection from Excel to JMP using the "Data Table" button.
    • Import your .xls or .xlsx file into JMP rather than using copy/paste.