Script to Change Column Names Using Column Properties

ShahirahLoqman

Hi, I am trying to script for my column names to be replaced with a specific column property called "Description". How do I extract whatever is stored under description and use that as my new column name?

 

I tried running my own script but it didn't really work out

dt = Current Data Table();
For( i = i, i <= N Cols( dt ), i++, 
 newname = (Column( dt, i ) << Get Column Properties("Description"));
Column( dt, i ) << Set Name(newname);
);

Appreciate the help!

 

 

 

 

txnelson

Great attempt......close but just a few, mainly syntax issues.  You need to start looking up examples of the functions you are attempting to use, in the Scripting Index.

// Isolate the code to only impacting this script
// and not all scripts
Names Default To Here( 1 );
dt = Current Data Table();
// i=1 rather than i=i
For( i = 1, i <= N Cols( dt ), i++, 
	// Get Properties rather than Get Column Properties
	newname = Column( dt, i ) << Get Properties( "Description" );
	// If there isn't a Description Column Property you do not 
	// want to change the column name
	If( Is String( newname ),
		Column( dt, i ) << Set Name( newname )
	);
);