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