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
ShahirahLoqman
Level II

How do I Script to Change Selected Column Names

Hi, is there a script for me to select the last 10 columns in my table (the ones after "Transition?") and add ".Cv" at the end of the original column name?

Column.PNG

 

I tried writing my script but it did not work:

 

dt = Current Data Table();

 

ColList = dt << get column names( string );

 

For( i = 11, i <= N Items( ColList ), i++, // set which column that look sat grade spec limits

 

NewName << ColList[i] || ".Cv";

Column( dt, ColList[i] ) << Set Name(NewName);

 

);

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: How do I Script to Change Selected Column Names

Here is a simplified version of your code that will add ".Cv" to the end of the specified columns

dt = Current Data Table();
 
For( i = 11, i <= N Cols( dt ), i++, 
 
	Column( dt, i ) << Set Name( (Column( dt, i ) << Get Name) || ".Cv" );
 
);
Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

Re: How do I Script to Change Selected Column Names

Here is a simplified version of your code that will add ".Cv" to the end of the specified columns

dt = Current Data Table();
 
For( i = 11, i <= N Cols( dt ), i++, 
 
	Column( dt, i ) << Set Name( (Column( dt, i ) << Get Name) || ".Cv" );
 
);
Jim

View solution in original post

Highlighted
ShahirahLoqman
Level II

Re: How do I Script to Change Selected Column Names

It works! Thank you so much !
Article Labels

    There are no labels assigned to this post.