How do I Script to Change Selected Column Names

[#1]

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!

[#2 · Accepted solution]

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

[#3]

It works! Thank you so much !

[#4]

somehow old but still good ;) ... thank you