News
We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
masum111bd
Level II

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

View solution in original post

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

View solution in original post

Highlighted
masum111bd
Level II

Re: Renaming columns with loop

Thanks David. It works fine.

0 Kudos
Highlighted
markschahl
Level V

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!