Set column names more efficiently?

nikles

Hi.  I'm looking for a scripting method to efficiently change the column names in my table to names I have contained in a list, without using a for loop.  Is there an operator or function that can perform this?  I'm thinking something like: dt << Set Column Names(newcolname_lis)?

 

With a for loop, I can do it this way:

...<BR />col_lis = dt << Get Column Names("String");
For(i=1, i<=NItems(col_lis), i++,
	dt:i << Set Name(newname_lis[i]);
);

But, my tables can contain > 20k columns, and this takes several minutes.  Any ideas on speeding this up?

 

Thanks.

 

 

 

ThuongLe

I have a crazy idea:
-Create blank table with your desired column names
-Copy and paste data from original table to newly-created one
Hope it helps