Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

Article Labels

    There are no labels assigned to this post.