topic Renaming columns with loop in Discussions

Renaming columns with loop

masum111bd — Thu, 30 Nov 2017 14:13:24 GMT

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

Re: Renaming columns with loop

David_Burnham — Thu, 30 Nov 2017 01:04:59 GMT

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

Re: Renaming columns with loop

masum111bd — Thu, 30 Nov 2017 16:29:40 GMT

Thanks David. It works fine.

Re: Renaming columns with loop

markschahl — Tue, 05 Dec 2017 18:44:15 GMT

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!