cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

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

Change column names in table importing names from a file

Hello,

 

I have a table containing sevaral columns > 150 usually.

I would like to create my new columns names into a file that i can modify easily and once created, change all column names of my table using the file.

 

thanks a lot for your help,

Vinc

2 REPLIES 2
txnelson
Super User

Re: Change column names in table importing names from a file

You can easily do this.

1. After inputting the data, go to the Columns Panel on the left side of the data table, and select all of the columns

change1.PNG

2. Go to the pull down menu "Edit" and select copy

change2.PNG

3. Paste the column names list into whatever editor you want......you can even use the JMP Script Editor, or Excel, etc.

4. Make the changes you want,

5. Copy the column names back into the paste buffer

6. Paste them back into JMP

 

Jim
ArmagVinc
Level II

Re: Change column names in table importing names from a file

Hi,

thanks a lot, so easy and no need of script to do that.

I'll save a lot of time in the future thanks to your precious help.

 

Thanks,

Vinc

Recommended Articles