BookmarkSubscribe
Choose Language Hide Translation Bar
masum111bd
Community Trekker

Renaming columns with loop

Hi,

I am trying to rename few columns. Basically I want to append "OFL" character at the end of original column name.

I trried this script but no success.

dt = Current Data Table();
For( i = 25, i <= N Cols( dt ), i++,
newname = :Column Name( dt, i )||"OFL";
Column( dt, i ) << Set Name( newname );
);
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
David_Burnham
Super User

Re: Renaming columns with loop

dt = Current Data Table();
For( i = 25, i <= N Cols( dt ), i++,
	cName = Column(dt,i) << Get Name;
	newname = cName|| "OFL";
	Column( dt, i ) << Set Name( newname );
);
-Dave
3 REPLIES 3
Highlighted
David_Burnham
Super User

Re: Renaming columns with loop

dt = Current Data Table();
For( i = 25, i <= N Cols( dt ), i++,
	cName = Column(dt,i) << Get Name;
	newname = cName|| "OFL";
	Column( dt, i ) << Set Name( newname );
);
-Dave
masum111bd
Community Trekker

Re: Renaming columns with loop

Thanks David. It works fine.

0 Kudos
markschahl
Community Trekker

Re: Renaming columns with loop

Just in case you want to do this with a second data table, here's how:

 

How-to-rename-columns-using-a-second-data-table

 

I use this a lot now since #TXNelson showed me how to do this!